Multiple choice technology databases

Which of the following views provides all the grants on all the objects in the database?

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

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

DBA_SYS_PRIVS provides information about all system privileges granted in the database. The other options are more specific: DBA_COL_PRIVS for column-level privileges, DBA_OBJ_PRIVS for object privileges, and DBA_TAB_PRIVS for table privileges. System privileges are the broadest category of grants.

Keep practicing — related questions