Using the AdventureWorks2014 Database, create the following application roles wi

Question

Using the AdventureWorks2014 Database, create the following application roles with the corresponding permissions (use CREATE statement):

Role

Permissions

Sales_Rep

SELECT, UPDATE, INSERT on Sales.SalesOrderDetail

Sales_Manager

DELETE on Sales.SalesOrderDetail

If you create database roles you will not be able to change roles for a user .

SQL statements and screenshots here

Using the AdventureWorks2014 database, create a proxy user (app_proxy) that will activate the roles you created in #1. Be sure to test your solution by logging on as application proxy and enabling different roles

Role

Permissions

Sales_Rep

SELECT, UPDATE, INSERT on Sales.SalesOrderDetail

Sales_Manager

DELETE on Sales.SalesOrderDetail

Explanation / Answer

2. Now, grant the role to the user:

GRANT Sales_rep TO User1;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.