nerdexam
Oracle

1Z0-007 · Question #151

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

The correct answer is D. USER_COL_PRIVS. The USER_COL_PRIVS data dictionary view will show the object privileges granted to the user on specific columns. Incorrect Answers A: There is no USER_TAB_PRIVS_MADE view in Oracle. B: The USER_TAB_PRIVS data dictionary view is used to show the object privileges granted to the…

Controlling User Access

Question

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

Options

  • AUSER_TAB_PRIVS_MADE
  • BUSER_TAB_PRIVS
  • CUSER_COL_PRIVS_MADE
  • DUSER_COL_PRIVS

How the community answered

(72 responses)
  • A
    6% (4)
  • B
    3% (2)
  • C
    13% (9)
  • D
    79% (57)

Explanation

The USER_COL_PRIVS data dictionary view will show the object privileges granted to the user on specific columns. Incorrect Answers A: There is no USER_TAB_PRIVS_MADE view in Oracle. B: The USER_TAB_PRIVS data dictionary view is used to show the object privileges granted to the user on the tables, not specific columns. C: There is no USER_COL_PRIVS_MADE view in Oracle.

Topics

#data dictionary#USER_COL_PRIVS#column-level privileges#object privileges

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-007 Practice