Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to obtain grants for a specific user by reading systables

Re: how to obtain grants for a specific user by reading systables

From: sybrandb <sybrandb_at_yahoo.com>
Date: 15 May 2006 01:07:13 -0700
Message-ID: <1147680433.597407.22970@j73g2000cwa.googlegroups.com> 





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 DBA


Received on Mon May 15 2006 - 03:07:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US