Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2005
    Posts
    92

    Unanswered: Determine the physical user who ran the Grant statement

    Hello,

    can someone please let me know how do I find out, the developer who ran a grant statement on a oracle database table along with the physical machine from which he ran.

    grant select on TABLEA to userA;

    Thanks
    pavan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    use DBMS_LOGMNR to extract the desired details
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2005
    Posts
    92
    I don't have privileges to execute the dbms_logmnr

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by pavan_test View Post
    I don't have privileges to execute the dbms_logmnr
    If you want to know who issued the GRANT, then somebody needs to run DBMS_LOGMNR.
    I don't know of any other way to obtain the answer.

    I can't push a string.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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