Working in multiple environments, I sometimes get tripped up by the RDBMS telling me a program unit doesn’t exist when I know it does.
What with system privileges either being granted directly, or via roles, I find the following query really useful in working out just what privileges I’ve got on an environment.
SELECT distinct privilege FROM dba_sys_privs WHERE grantee = USER OR grantee IN ( SELECT granted_role FROM dba_role_privs START WITH grantee = USER CONNECT BY PRIOR granted_role = grantee) ORDER BY 1
As a SQL Developer user, I drop this into my User Defined Reports folder so it’s always handy.
Advertisements