Object Privileges  «Prev  Next»

Grant Option and Revoke - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which action removes the GRANT OPTION for an object privilege?
Please select the best answer.
  A. Use the REVOKE command with the GRANT OPTION clause
  B. REVOKE the privilege for the object
  C. REVOKE the privilege for the object and then regrant the privilege without the GRANT OPTION
  D. Use the GRANT NO OPTION clause with the GRANT command

2. Which two actions could you take to grant a user SELECT, UPDATE, INSERT, DELETE, and REFERENCES privileges?
Please select all the correct answers.
  A. Grant ALL with the GRANT OPTION
  B. Grant ALL to PUBLIC and then revoke the ALTER and INDEX privileges
  C. Grant each of the privileges individually
  D. Grant ALL privileges and then REVOKE the ALTER and INDEX privileges


3. In order to be able to REVOKE a privilege, it must:
Please select the best answer.
  A. Reside in your schema
  B. Have been granted by you
  C. Be accessible to you
  D. Have the GRANT OPTION clause assigned for you