oracle all tab privs,Oracle 11g: USER_TAB_PRIVS and ALL_TAB_PRIVS | 学步园

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