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 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
Get step-by-step solutions from verified subject matter experts
