User Security

Submitted by dmann on Tue, 05/12/2009 - 14:42

Show Privileges for a Role

For example, EXECUTE_CATALOG_ROLE: 
select privilege, table_name 
  from role_tab_privs 
 where role='EXECUTE_CATALOG_ROLE'
 order by 2;