EnsurepassQUESTION 1 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;   Correct Answer: B Explanation: REVOKE - permanently removes Read more [...]