____ shows only direct roles granted to the current schema.
A) SESSION_PRIVS
B) SESSION_ROLES
C) USER_SYS_PRIVS
D) USER_ROLE_PRIVS

Question

Quizplus · Accepted Answer

USER_ROLE_PRIVS will show only the direct roles granted to the current schema. SESSION_PRIVS will show system privileges that have been granted to the current session. SESSION_ROLES will show both direct and inherited roles for the current session. USER_SYS_PRIVS will show system privileges that have been granted to the current user.

____ Shows Only Direct Roles Granted to the Current Schema