Question

Each of the outcomes listed below is a result of executing the following script except for one. Which one? CREATE ROLE ExampleRole; ALTER ROLE db_datareader ADD MEMBER ExampleRole; GRANT INSERT,UPDATE ON Vendors TO ExampleRole; DENY INSERT ON Vendors TO ASmith; ALTER ROLE ExampleRole ADD MEMBER ASmith;
a. By being assigned to the role db_datareader, a user would be granted INSERT and UPDATE permission to the Vendors table and SELECT permission to all user tables.
b. The user named ASmith can’t be granted INSERT permission to the Vendors table by being assigned to the role ExampleRole.
c. By being assigned to the role ExampleRole, a user would be granted INSERT and UPDATE permission to the Vendors table and SELECT permission to all user tables.
d. The user named ASmith is granted UPDATE permission to the Vendors table and SELECT permission to all user tables.

Answer 1

Answer:

Option (A) is the correct answer to the following question.

Explanation:

The following option is correct because with the help of the database we can create the table and the user would be given the permission of INSERT, UPDATE the table and also give permission to SELECT all user tables.

The option B is incorrect because the following table can get permission to input to the vendor's table.

The option C is incorrect because we can be assigning to the role db_datareader.