RACHELP | Solutions for Oracle Real Applications Clusters

Scripts

Topic	RAC
Description	System privileges to roles and users:
Content	Found th following query which is very useful. Added it so can reuse it when needed. select lpad(' ', 2level) \|\| c "Privilege, Roles and Users" from ( / THE PRIVILEGES / select null p, name c from system_privilege_map where name like upper('%&enter_privilege%') / THE ROLES TO ROLES RELATIONS / union select granted_role p, grantee c from dba_role_privs / THE ROLES TO PRIVILEGE RELATIONS */ union select privilege p, grantee c from dba_sys_privs ) start with p is null connect by p = prior c;