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

Category: SQLWhich data dictionary table can be used to show the object privileges granted to the user on specific columns?
Editor">Editor Staff asked 2 years 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">Editor Staff answered 2 years 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.