RACHELP | Solutions for Oracle Real Applications Clusters

Scripts

Topic	RAC
Description	Users to roles and system privileges
Content	Found the following very usefull query, add it to the collection so can reuse it. select lpad(' ', 2level) \|\| granted_role "User, his roles and privileges" from ( / THE USERS / select null grantee, username granted_role from dba_users where username like upper('%&enter_username%') / THE ROLES TO ROLES RELATIONS / union select grantee, granted_role from dba_role_privs / THE ROLES TO PRIVILEGE RELATIONS */ union select grantee, privilege from dba_sys_privs ) start with grantee is null connect by grantee = prior granted_role;