Mega Code Archive
Searches for grants made by users other than the table owners
<![CDATA[
SQL> break on Grantor skip 1 on Owner on Table_Name
SQL> select
2 Grantor, /*Account that made the grant*/
3 Owner, /*Account that owns the table*/
4 Table_Name, /*Name of the table*/
5 Grantee, /*Account granted access*/
6 Privilege, /*Privilege granted*/
7 Grantable /*Granted with admin option?*/
8 from DBA_TAB_PRIVS
9 where rownum < 10
10 order by Grantor, Owner, Table_Name, Grantee, Privilege;
GRANTOR OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------
GRANTEE PRIVILEGE GRA
------------------------------ ---------------------------------------- ---
SYS SYS CCOL$
CTXSYS SELECT YES
COL$
CTXSYS SELECT YES
CON$
CTXSYS SELECT YES
ICOL$
CTXSYS SELECT YES
IND$
CTXSYS SELECT YES
TS$
CTXSYS SELECT YES
USER$
CTXSYS SELECT YES
FLOWS_020100 SELECT YES
XDB SELECT NO
SQL>
SQL>
]]>