Multiple choice technology databases

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle's USER_COL_PRIVS data dictionary view lists column-level object privileges granted to the current user. USER_TAB_PRIVS shows table-level privileges, while _MADE views show privileges granted on objects owned by the user rather than privileges granted to them.