SQL> SET LINESIZE 400
SQL> SET PAGESIZE 400
SQL> SELECT * FROM USER_TAB_PRIVS WHERE GRANTEE='XIAYE';
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
XIAYE SYS SHIPS SYS UPDATE NO NO
XIAYE SYS SHIPS SYS SELECT NO NO
XIAYE SYS SHIPS SYS INSERT NO NO
XIAYE SYS SHIPS SYS DELETE NO NO
SQL> SELECT * FROM ALL_TAB_PRIVS WHERE GRANTEE='XIAYE';
GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME PRIVILEGE GRA HIE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --- ---
SYS XIAYE SYS SHIPS UPDATE NO NO
SYS XIAYE SYS SHIPS SELECT NO NO
SYS XIAYE SYS SHIPS INSERT NO NO
SYS XIAYE SYS SHIPS DELETE NO NO
转载于:https://www.cnblogs.com/duadu/archive/2012/02/10/6335532.html