You are a database security consultant working at a new client. You have been working on resolving some complex security issues on this client’s SQL Server system. You have decided to eliminate a DENY permission setting that is blocking access for GRANTed permissions. How can you eliminate this DENY setting?

You are a database security consultant working at a new client. You have been working on resolving some complex security issues on this client’s SQL Server system. You have decided to eliminate a DENY permission setting that is blocking access for GRANTed permissions. How can you eliminate this DENY setting?

You are a database security consultant working at a new client. You have been working on resolving some complex security issues on this client’s SQL Server system. You have decided to eliminate a DENY permission setting that is blocking access for GRANTed permissions. How can you eliminate this DENY setting?


Answer: – Use REVOKE to remove the DENY setting.

(The correct way to remove a DENY setting is to use the REVOKE command. There is no ALLOW command nor a GRANT WITH OVERRIDE or DENY DENY command.)