Two developers named IversonB and JacksonT need to be able to create objects in the Inventory database as part of their regular duties. You need to give them the ability to create these objects without giving them too much author on the server. Choose the most secure way to do this.

Two developers named IversonB and JacksonT need to be able to create objects in the Inventory database as part of their regular duties. You need to give them the ability to create these objects without giving them too much author on the server. Choose the most secure way to do this.

Two developers named IversonB and JacksonT need to be able to create objects in the Inventory database as part of their regular duties. You need to give them the ability to create these objects without giving them too much author on the server. Choose the most secure way to do this.


Answer: – Add IversionB and JacksonT to the db_ddladmin fixed database role, and instruct them to create objects as DBO.

(Adding users to the db_ddladmin role is the most secure way to accomplish this goal. Adding them to the db_owner or sysadmin role would grant them too much authority over the database and would not maintain strict security. Having them create objects as DBO will avoid broken ownership chains, as well.)