Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to obtain grants for a specific user by reading systables
You'd better query the table DICT for this type of question.
It contains a list of all tables (with description) in the
datadictionary.
In your case, you'll need dba_tab_privs and dba_role_privs (grants
could have been made to a role)
Hth
-- Sybrand Bakker Senior Oracle DBAReceived on Mon May 15 2006 - 03:07:13 CDT