【DB笔试面试546】在Oracle中，关于SESSION_PRIVS字典视图，哪个陈述是正确的？

SYS@oradg11g > create user lhrxxt identified by lhr;

User created.

SYS@oradg11g > grant resource,connect to lhrxxt;

Grant succeeded.

SYS@oradg11g > conn lhrxxt/lhr
Connected.
LHRXXT@oradg11g > select * from SESSION_PRIVS;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

10 rows selected.

LHRXXT@oradg11g > conn / as sysdba
Connected.
SYS@oradg11g > create table sys.xxt as select * from dual;

Table created.

SYS@oradg11g > grant select on sys.xxt to lhrxxt;

Grant succeeded.

SYS@oradg11g > conn lhrxxt/lhr
Connected.
LHRXXT@oradg11g > select * from SESSION_PRIVS;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE

10 rows selected.

LHRXXT@oradg11g > select * from user_TAB_PRIVS;

GRANTEE     OWNER   TABLE_NAME    GRANTOR  PRIVILEGE   GRA HIE
----------- ------- ------------- -------- ----- ----- --- ---
LHRXXT      SYS     XXT           SYS      SELECT      NO  NO