Wednesday, March 21, 2012

Grants for a User in Oracle Database

SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv  
 
FROM table_privileges 
 
WHERE grantee = <theUser> 
 
ORDER BY owner, table_name;

No comments: