Schema permissions

A database administrator needs to perform specific actions for objects in the database. You need to ensure the administrator can perform the tasks using the principle of least privilege. Which schema permissions should you assign? To answer, select the appropriate permissions for each task in the answer area. NOTE: Each correct selection is worth one point.

---

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-schema-transact-sql?view=sql-server-2017#permissions

https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-database-collation?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/t-sql/statements/drop-schema-transact-sql?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-tables-database-engine?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-2017#permissions

---

---

Discussion:

Brandontay09

Are they really all ALTER?

als2kool

Yes they are all alter

Bartek

1. EXECUTE 2.CONTROL 3.ALTER 4. INSERT

Twigit

Execute will not allow you to create stored procedures, only execute them. Insert will not allow you to drop tables, only insert into them. I would say Alter, Control, Alter, Alter

gtc108

1.Execute 2.Control 3.Alter 4.Control

gtc108

1.Alter 2.Control 3.Alter 4.Control