Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to show what has been granted
If you are logged in as that user you can just issue
SELECT * FROM SESSION_PRIVS;
SELECT * FROM SESSION_ROLES;
regards
Srivenu
Received on Mon Oct 14 2002 - 00:22:22 CDT