03 – The CCC Switch

By default SQL server will tend to be generous when granting permission in your systems. If you are in a group or have permissions granted on an object or to perform a task that trumps any other deny statement.

That can get tricky to troubleshoot when you have to start securing things more.

Thankfully, there is a single setting in your SQL Server configuration that changes the way that works and makes a Deny statements truly mean NO.

 

Duration: 30-minute discussion and hands-on lab work.