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.
- SecuritysettingsSQL Server
- Date:September 1, 2019
- Time:10:00 am
- Event:Go Beyond the Basics and Have Fun with SQL Server Security