Multiple choice technology databases

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

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.

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.

Keep practicing — related questions