DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Who granted a privilege and when did they do it?

  1. #1
    Join Date
    Aug 2000
    Posts
    462
    How can I find out who granted a privilege, and when it was granted by querying the database?

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    To find who granted object privileges you can query column GRANTOR in DBA_TAB_PRIVS and DBA_COL_PRIVS. For system privileges and roles there is no way to find out this information from the dictionary. Also there is no way to find out when particular privilege/role was granted by querying the dictionary. You should turn auditing on or use log miner to keep track of those information.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    In this particular case, someone was granted execute on DBMS_SQL. I'm looking for whatever I can find about who/when the grant occurred.

    Where should I look for this?

    Thanks!


  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    SELECT grantor FROM dba_tab_privs WHERE owner = 'SYS' AND table_name = 'DBMS_SQL' AND grantee = 'SCOTT';

    will show who granted execute on SYS.DBMS_SQL to user SCOTT.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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