Security Roles   «Prev  Next»

Implementation of Roles - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following runtime SQL commands would disable the assigned role of BIDDER?
Please select the best answer.
  A. SET ROLE BIDDER
  B. SET ROLE ADMINISTRATOR
  C. SET ROLE ALL EXCEPT ADMINISTRATOR
  D. SET ROLE ALL

2. Which two pieces of syntax give a user the ability to grant a role to other users?
Please select all the correct answers.
  A. GRANT ROLE to the user
  B. The WITH GRANT OPTION for the grant
  C. The WITH ADMIN OPTION for the grant
  D. You cannot allow a user to re-grant a role

3. You are a user, BID1, who has been granted the SELECT privilege for the BID table. You are also assigned a role, BIDDER, which has the INSERT and UPDATE privileges assigned to it.

You create a stored procedure while the BIDDER role is enabled. Which privileges does the stored procedure have on the BID table?
Please select the best answer.
  A. None
  B. SELECT
  C. INSERT and UPDATE
  D. SELECT, INSERT, and UPDATE