grant all 与grant select 有什么区别

U1>CONN / AS SYSDBA
Connected.
SYS>GRANT SELECT ON SCOTT.EMP TO U1;

Grant succeeded.

SYS>CONN U1/U1
Connected.
U1>SELECT * FROM USER_TAB_PRIVS;

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
--------------- --------------- --------------- ------------------------------ --------------- --- ---
U1 SCOTT EMP SCOTT SELECT NO NO

U1>CONN / AS SYSDBA
Connected.
SYS>GRANT ALL ON SCOTT.EMP TO U1;

Grant succeeded.

U1>SELECT * FROM USER_TAB_PRIVS;

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
--------------- --------------- --------------- ------------------------------ -------------------- --- ---
U1 SCOTT EMP SCOTT FLASHBACK NO NO
U1 SCOTT EMP SCOTT DEBUG NO NO
U1 SCOTT EMP SCOTT QUERY REWRITE NO NO
U1 SCOTT EMP SCOTT ON COMMIT REFRESH NO NO
U1 SCOTT EMP SCOTT REFERENCES NO NO
U1 SCOTT EMP SCOTT UPDATE NO NO
U1 SCOTT EMP SCOTT INSERT NO NO
U1 SCOTT EMP SCOTT INDEX NO NO
U1 SCOTT EMP SCOTT DELETE NO NO
U1 SCOTT EMP SCOTT ALTER NO NO
U1 SCOTT EMP SCOTT SELECT NO NO