Question: Select Editing Q4) You administer a Database Server you need to create 2 Sql server user with Sal server authentication and they will able to

 Select Editing Q4) You administer a Database Server you need to

Select Editing Q4) You administer a Database Server you need to create 2 Sql server user with Sal server authentication and they will able to access the "Employee" table in "ITCS336" database only with select, update and delete permissions and they are unable to insert data to the table. Requirements: 1. In ITCS336 database create "ABC" role. 2. Specify this role to be implement on the Employee table only. 3. Grant select, update and delete permission to this role 4. Deny insert permission from this role. 5. Create 2 Sql server users user with Sql server authentication and assign them to "ABC" role (Make screen shot for your Answer Steps). (5X4 = 20 M)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!