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
Oracle 11g: USER_TAB_PRIVS and ALL_TAB_PRIVS
最新推荐文章于 2021-04-13 06:07:18 发布