Which Transact-SQL statement should you use?

You have a user named John. He has SELECT access to the Sales schema. You need to eliminate John’s SELECT access rights from the Sales.SalesOrder table without affecting his other permissions.
Which Transact-SQL statement should you use?

You have a user named John. He has SELECT access to the Sales schema. You need to eliminate John’s SELECT access rights from the Sales.SalesOrder table without affecting his other permissions.
Which Transact-SQL statement should you use?

A.
DROP USER John;

B.
DENY SELECT ON Sales.SalesOrder TO John;

C.
GRANT DELETE ON Sales.SalesOrder TO John;

D.
REVOKE SELECT ON Sales.SalesOrder FROM John;



Leave a Reply 1

Your email address will not be published. Required fields are marked *