Which additional action(s) should you take?

You are a database administrator on an instance of SQL Server 2008. You have implemented database roles and used role membership to grant all user permissions.
Your company has recently hired a contractor who needs permissions associated with the Developer role. The Developer role has permission to query all tables, as well as to create database objects. Due to privacy concerns, you do not want the contractor to be able to access specific table columns in the Employee table, which the Developer role allows.
You create the Contractor user. You want to assign the appropriate permissions with the least administrative effort.
Which additional action(s) should you take?
A. Create a new database role with only the allowed contractor permissions and make the Contractor user a member of the new role.
B. Create an application role for the Contractor user.
C. Make the Contractor a member of the Developer role and explicitly deny permissions at the column level.
D. Explicitly grant the allowed contractor permissions to the Contractor user.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.