70-432 · Question #193
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…
The correct answer is D. GRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1. See the full explanation below for the reasoning.
Question
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?
Options
- AGRANT CREATE TABLE, CREATE PROCEDURE TO User1;
- BALTER AUTHORIZATION ON SCHEMA::Reporting TO User1;
- CGRANT CONTROL ON SCHEMA::Reporting TO User1;
- DGRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1;
How the community answered
(68 responses)- A3% (2)
- B6% (4)
- C12% (8)
- D79% (54)
Community Discussion
No community discussion yet for this question.