Wednesday, February 20, 2008

What tables and procs user has access to

Shows what tables or Procedures a database user has access to.
eg: select, insert, execute...

select * from dba_tab_privs where grantee in (select granted_role from dba_role_privs where grantee = 'CXDEV') or grantee = 'CXDEV'

*********************************
keyword user priv access table
*********************************

No comments: