To view the object privileges granted to the 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 the USER_TAB_PRIVS_MADE table provides information about the object privileges the user has granted to other users, not the privileges granted to the user on specific columns.
Option B) USER_TAB_PRIVS - This option is incorrect because the USER_TAB_PRIVS table provides information about the object privileges granted to the user on tables, not specific columns.
Option C) USER_COL_PRIVS_MADE - This option is incorrect because the USER_COL_PRIVS_MADE table provides information about the column privileges the user has granted to other users, not the privileges granted to the user on specific columns.
Option D) USER_COL_PRIVS - This option is correct because the USER_COL_PRIVS table provides information about the column privileges granted to the user, including the privileges granted on specific columns of tables.
The correct answer is D. This option is correct because querying the USER_COL_PRIVS table allows you to view the object privileges granted to the user on specific columns.