Which statement is true regarding the SESSION_PRIVS dictionary view?
A.
It contains the current object privileges available in the user session.
B.
It contains the current system privileges available in the user session.
C.
It contains the object privileges granted to other users by the current user session.
D.
It contains the system privileges granted to other users by the current user session.
SESSION_PRIVS describes the privileges that are currently available to the user.
A newly created user cannot connect to the database until granted the CREATE SESSION system privilege.
select * from SESSION_PRIVS;
Result:
CREATE USER
CREATE ANY SEQUENCE
GRANT ANY OBJECT PRIVILEGE
CREATE ANY TRIGGER
CREATE ANY SEQUENCE
ALTER ANY SEQUENCE
A system privilege is the right to perform a particular action or to perform an action on any object of a particular type. Objects include tables, views, materialized views, synonyms, indexes, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages. Only the instance administrator or a user with ADMIN privilege can grant or revoke system privileges.
An object privilege is the right to perform a particular action on an object or to access another user’s object. Objects include tables, views, materialized views, indexes, synonyms, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages.
Correct answer is B