when was the DBA role given ?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: when was the DBA role given ?

  1. #1
    Join Date
    Mar 2001
    Posts
    42

    when was the DBA role given ?

    Gurus,

    One of the user has assigned DBA role to his id illegally. I want to identify when (Date) was the DBA role assigned by that user. Can anybody give a light on this issue ? Thanks in advance.

    Rgds,

    Saravanan.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Enable auditing..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    I hope that you are using auditing:
    Check this link for access/use of privileges
    http://download-west.oracle.com/docs...t.htm#ADMIN026
    Able was I ere I saw Elba

  4. #4
    Join Date
    Mar 2001
    Posts
    42
    hi,

    we didn't enable audit. Without using Audit option, is there anyway to find out this issue?

    Rgds,

    saravanan.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Throw him and every other developer a well deserved beatin'.
    I have yet to meet a developer or user that would not benefit greatly from a good ol' fashioned beatin.



    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Mr.H I am eagerly awaiting your white paper on "The effective use of physical violence in database administration."

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by DaPi
    Mr.H I am eagerly awaiting your white paper on "The effective use of physical violence in database administration."
    C'mon, do I lie? You know there is a part of you and every other DBA out there that is applauding my forthcoming nature, and agreeing wholeheartedly.

    I am the voice of the inhibited, I speak for the supressed.

    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: when was the DBA role given ?

    Originally posted by shravansam
    Gurus,

    One of the user has assigned DBA role to his id illegally. I want to identify when (Date) was the DBA role assigned by that user. Can anybody give a light on this issue ? Thanks in advance.

    Rgds,

    Saravanan.
    If you are using 9i and are in archive log mode investigate logminer
    Last edited by stmontgo; 04-20-2004 at 02:20 PM.
    I'm stmontgo and I approve of this message

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Mr.Hanky
    Throw him and every other developer a well deserved beatin'.
    I have yet to meet a developer or user that would not benefit greatly from a good ol' fashioned beatin.



    MH
    Hm, I wonder where is developer's guilt with this incidence... Granting someone (or enabling someone not authorised to grant) a DBA privilege- where do dvelopers come to play here???? Isn't here a DBA that deserves a decent beatin'? And it seems to me very likely that the one that raised this question here is the one that is responsible. But before you all start beating him/her - that's only a guess, I might be wrong here.....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by jmodic
    Hm, I wonder where is developer's guilt with this incidence... Granting someone (or enabling someone not authorised to grant) a DBA privilege- where do dvelopers come to play here???? Isn't here a DBA that deserves a decent beatin'? And it seems to me very likely that the one that raised this question here is the one that is responsible. But before you all start beating him/her - that's only a guess, I might be wrong here.....
    HAVING THE CAPABILITY AND USING IT ARE TWO ENTIRELY DIFFERENT THINGS.

    I may have the ability to go out and buy a gun, in fact I do. Using it is an entirely different matter.

    MH
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width