Multiple choice technology programming languages

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

USER_COL_PRIVS shows column-level object privileges granted TO the current user. USER_TAB_PRIVS shows table-level privileges received. The _MADE variants show privileges granted BY the user. For column-specific privileges, query USER_COL_PRIVS.