You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database
named DB1.
You create a new user named User1 in the DB1 database. No additional permissions have
been assigned to User1 or the public role. User1 will interact with database objects stored in
a new schema named Reporting. The other objects in the DB1 database are owned by the
dbo and are contained in a schema named Operations.
You need to grant the minimum necessary permission to User1 to create tables and stored
procedures in the Reporting schema.
You also need to ensure that User1 cannot alter any of the objects in the Operations
schema.
Which Transact-SQL statements should you execute?
A.
GRANT CREATE TABLE, CREATE PROCEDURE TO User1; DENY CONTROL ON
SCHEMA: Operations TO User1;
B.
ALTER AUTHORIZATION ON SCHEMA::Reporting TO User1;
C.
GRANT CONTROL ON SCHEMA::Reporting TO User1; DENY CONTROL ON
SCHEMA::Operations TC User1;
D.
GRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1;