patriotpacer
asked on
Oracle - View roles assigned to my username
In oracle is there a way to see what roles/permissions are assigned to my username?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try these:
SELECT * FROM USER_SYS_PRIVS;
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;
SELECT * FROM USER_SYS_PRIVS;
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;
:0 oops no refresh - too late (again) sorry
Way late this time Paul!!! ;)
yes, had to put a cat to bed :)
ASKER