Monday, April 16, 2012

List user or table privileges in Oracle

This morning I was asked by the auditors to give them a list of privileges which have been granted to users USER_A and USER_B. You can do this by using the following SQL:
select GRANTEE, TABLE_NAME, PRIVILEGE from dba_tab_privs 
where lower(grantee) in ('user_a', 'user_b') order by grantee;
Post a Comment