🎴 Flashcard Mode
databases Online Quiz - 42
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?
AnswerClick to flip back
A
USER_COL_PRIVS
💡 Explanation:
Oracle's data dictionary provides several views for tracking privileges. USER_COL_PRIVS displays column-level privileges granted to the current user, while USER_COL_PRIVS_MADE shows column privileges the user granted to others. USER_TAB_PRIVS and USER_TAB_PRIVS_MADE are for table-level privileges.