Multiple choice

Which data dictionary view should be used to get a list of object privileges for all database users?

  1. DBA_TAB_PRIVS

  2. ALL_TAB_PRIVS

  3. USER_TAB_PRIVS

  4. ALL_TAB_PRIVS_MADE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DBA_TAB_PRIVS is a data dictionary view that displays all table privileges granted to all users in the database, making it the comprehensive choice for reviewing object privileges system-wide. ALL_TAB_PRIVS shows only table privileges accessible to the current user (granted to or by the current user). USER_TAB_PRIVS shows only table privileges granted to the current user. ALL_TAB_PRIVS_MADE shows privileges granted by the current user to others. For a complete view across all users, DBA_TAB_PRIVS is required.

Keep practicing — related questions