Multiple choice technology databases

A user U01 is logging in with his ID What data dictionary view will give details on available system privileges for him

  1. ALL_SYS_PRIVS

  2. USER_SYS_PRIVS

  3. ALL_ROLE_PRIVS

  4. USER_ROLE_PRIVS
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

USER_SYS_PRIVS shows the system privileges granted specifically to the current user. ALL_SYS_PRIVS would show all system privileges in the database (not filtered for the user). The ROLE_PRIVS views are for role privileges, not system privileges. For user U01 checking their own system privileges, USER_SYS_PRIVS is correct.

Keep practicing — related questions