Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Need system/user view ( like dba_role_privs ) for table grants?
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