Which data dictionary table can be used to show the object privileges granted to the user on specific columns?

DWQA QuestionsCategory: SQLWhich data dictionary table can be used to show the object privileges granted to the user on specific columns?
Editor Staff asked 9 months ago

Which data dictionary table can be used to show the object privileges granted to the user on specific columns?

  1. USER_TAB_PRIVS_MADE
  2. USER_COL_PRIVS_MADE
  3. USER_TAB_PRIVS
  4. USER_COL_PRIVS
1 Answers
Editor Staff answered 9 months ago

Answer: 4-USER_COL_PRIVS
Explanation: The USER_COL_PRIVS data dictionary table will display the object privileges granted to the user on specific columns. The USER_TAB_PRIVS data dictionary table will display the object privileges granted to the user on the tables. Options A and B are not data dictionary.