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 -> Need system/user view ( like dba_role_privs ) for table grants?

Need system/user view ( like dba_role_privs ) for table grants?

From: Rob Williamson <robw_at_physics.umd.edu>
Date: Sat, 13 May 2006 16:17:34 -0400
Message-ID: <44663EDE.D59AF4A6@physics.umd.edu>


I found a view in my documentation called dba_tab_grants but I can not seem to
find it in the database. I tried user_tab_grants as well. I am using 9i on Red Hat by the way.

I want to be able to see the privelages I granted in a table after I create them like:

GRANT CREATE SYNONYM TO storwww;

GRANT SELECT, INSERT, UPDATE, DELETE ON storowner.unit_of_measure TO storwww;

then after the grant script be able to see them all and be sure they exist and are valid.

dba_sys_privs and dba_col_privs don't do it.

Thanks
Rob Received on Sat May 13 2006 - 15:17:34 CDT

Original text of this message

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