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?
  1. USER_TAB_PRIVS,
  2. USER_TAB_PRIVS_MADE, and
  3. USER_TAB_PRIVS_RECD?

Please select the best answer.
  A. GRANTOR
  B. GRANTEE
  C. OWNER
  D. TABLE_NAME