Object Privileges  «Prev  Next»

Listing Privileges in Data Dictionary View - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which data dictionary view does not contain information about grants on a column?
Please select the best answer.
  A. USER_COL_PRIVS
  B. USER_TAB_PRIVS
  C. USER_COL_PRIVS_MADE
  D. USER_COL_PRIVS_RECD

2. You want to find out whether a particular user, SCOTT, has been granted privileges on a particular table, COIN. Which two queries could get you that information?
Please select all the correct answers.
  A. SELECT * FROM ALL_COL_PRIVS WHERE USER_NAME = 'SCOTT'
  B. SELECT * FROM ALL_TAB_PRIVS WHERE USER_NAME = 'SCOTT' AND TABLE_NAME = 'COIN'
  C. SELECT * FROM USER_TAB_PRIVS_RECD WHERE TABLE_NAME = 'COIN' while logged in as user SCOTT
  D. SELECT * FROM ALL_TAB_PRIVS_MADE WHERE USER_NAME = 'SCOTT' AND TABLE_NAME = 'COIN'


3. Which column is not in all of these data dictionary views--USER_TAB_PRIVS, USER_TAB_PRIVS_MADE, and USER_TAB_PRIVS_RECD?
Please select the best answer.
  A. GRANTOR
  B. GRANTEE
  C. OWNER
  D. TABLE_NAME