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_RECD

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS_RECD
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

USER_COL_PRIVS_RECD shows column-level object privileges that the current user has RECEIVED. The other options show different privilege views: USER_TAB_PRIVS_MADE (table privileges granted to others), USER_TAB_PRIVS_RECD (table privileges received), USER_COL_PRIVS_MADE (column privileges granted to others).

Keep practicing — related questions