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

Rob Williamson <robw_at_physics.umd.edu> wrote in news:44663EDE.D59AF4A6 @physics.umd.edu:

> I found a view in my documentation called dba_tab_grants

Then the documentation is incorrect.
No such view exists in V9.2 or V10.2

 desc user_tab_privs

 Name                                      Null?    Type
 ----------------------------------------- -------- 
----------------------------
 GRANTEE                                   NOT NULL VARCHAR2(30)
 OWNER                                     NOT NULL VARCHAR2(30)
 TABLE_NAME                                NOT NULL VARCHAR2(30)
 GRANTOR                                   NOT NULL VARCHAR2(30)
 PRIVILEGE                                 NOT NULL VARCHAR2(40)
 GRANTABLE                                          VARCHAR2(3)
 HIERARCHY                                          VARCHAR2(3)

SQL> Received on Sat May 13 2006 - 16:16:35 CDT