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;
B