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


Correct Option: D

AI Explanation

To view the object privileges granted to a user on specific columns, you should query the USER_COL_PRIVS data dictionary table.

Let's go through each option to understand why it is correct or incorrect:

Option A) USER_TAB_PRIVS_MADE - This option is incorrect because USER_TAB_PRIVS_MADE is used to view the object privileges granted by the user.

Option B) USER_TAB_PRIVS - This option is incorrect because USER_TAB_PRIVS is used to view the object privileges granted to the user on tables or views, not on specific columns.

Option C) USER_COL_PRIVS_MADE - This option is incorrect because USER_COL_PRIVS_MADE is used to view the column privileges granted by the user.

Option D) USER_COL_PRIVS - This option is correct because USER_COL_PRIVS is the data dictionary table that should be queried to view the object privileges granted to the user on specific columns.

Therefore, the correct answer is D) USER_COL_PRIVS. This option is correct because it provides information about the object privileges granted to the user on specific columns.

Find more quizzes: