Which of the following views will display the privileges currently enabled for a user?
A) CURRENT_PRIVS
B) SESSION_PRIVILEGES
C) SESSION_PRIVS
D) CURRENT_PRIVILEGES

Question

Which of the following views will display the privileges currently enabled for a user?​
A) ​CURRENT_PRIVS
B) ​SESSION_PRIVILEGES
C) ​SESSION_PRIVS
D) ​CURRENT_PRIVILEGES

Quizplus · Accepted Answer

The correct view for displaying the privileges currently enabled for a user in Oracle Database is SESSION_PRIVS. This view lists all system privileges granted to the current user, either directly or through roles.

Which of the Following Views Will Display the Privileges Currently