|
SQL>
SQL>
SQL> SELECT b.owner || '.' || b.table_name obj,
2 b.privilege what_granted, b.grantable,
3 a.username
4 FROM sys.dba_users a, sys.dba_tab_privs b
5 WHERE a.username = b.grantee
6 and rownum < 50
7 ORDER BY 1,2,3;
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.ARGUMENT$
SELECT YES CTXSYS
SYS.CCOL$
SELECT YES CTXSYS
SYS.CDEF$
SELECT YES CTXSYS
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.COL$
SELECT YES CTXSYS
SYS.CON$
SELECT YES CTXSYS
SYS.ICOL$
SELECT YES CTXSYS
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCEXP
ALTER NO SYSTEM
SYS.INCEXP
DEBUG NO SYSTEM
SYS.INCEXP
DELETE NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCEXP
FLASHBACK NO SYSTEM
SYS.INCEXP
INDEX NO SYSTEM
SYS.INCEXP
INSERT NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCEXP
ON COMMIT REFRESH NO SYSTEM
SYS.INCEXP
QUERY REWRITE NO SYSTEM
SYS.INCEXP
REFERENCES NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCEXP
SELECT NO SYSTEM
SYS.INCEXP
UPDATE NO SYSTEM
SYS.INCFIL
DEBUG NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCFIL
DELETE NO SYSTEM
SYS.INCFIL
FLASHBACK NO SYSTEM
SYS.INCFIL
INDEX NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCFIL
INSERT NO SYSTEM
SYS.INCFIL
ON COMMIT REFRESH NO SYSTEM
SYS.INCFIL
QUERY REWRITE NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCFIL
REFERENCES NO SYSTEM
SYS.INCFIL
SELECT NO SYSTEM
SYS.INCFIL
UPDATE NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCVID
ALTER NO SYSTEM
SYS.INCVID
DEBUG NO SYSTEM
SYS.INCVID
DELETE NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCVID
FLASHBACK NO SYSTEM
SYS.INCVID
INDEX NO SYSTEM
SYS.INCVID
INSERT NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCVID
ON COMMIT REFRESH NO SYSTEM
SYS.INCVID
QUERY REWRITE NO SYSTEM
SYS.INCVID
REFERENCES NO SYSTEM
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.INCVID
SELECT NO SYSTEM
SYS.INCVID
UPDATE NO SYSTEM
SYS.IND$
SELECT YES CTXSYS
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.OBJ$
SELECT NO FLOWS_020100
SYS.OBJ$
SELECT YES CTXSYS
SYS.SYN$
SELECT YES CTXSYS
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.SYSAUTH$
SELECT YES CTXSYS
SYS.TAB$
SELECT YES CTXSYS
SYS.TS$
SELECT YES CTXSYS
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.USER$
SELECT NO XDB
SYS.USER$
SELECT YES CTXSYS
SYS.USER$
SELECT YES FLOWS_020100
OBJ
-------------------------------------------------------------
WHAT_GRANTED GRA USERNAME
---------------------------------------- --- ------------------------------
SYS.VIEW$
SELECT YES CTXSYS
49 rows selected.
SQL>
|