Which TransactSQL 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 TransactSQL 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 TransactSQL 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 0

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