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
D Correct answer
Explanation

In Oracle databases, DBA_TAB_PRIVS provides information about all grants and privileges on all tables, views, and other objects in the database. DBA_SYS_PRIVS shows system privileges, while DBA_COL_PRIVS is limited to column-level grants.