Join Gerry O'Brien for an in-depth discussion in this video SQL Server permissions, part of Securing SQL Server 2012.
SQL Server uses secureables as the database…objects to which security can be applied.…Accessing any of the secureables in SQL Server…requires that the login or user have permissions.…The permissions in SQL Server follow certain naming conventions,…some of which offer insight into the permission itself.…It's important to understand these naming conventions, so you can truly…understand the permissions that you will be assigning to your users.…The first permission we look at is the control.…Control is similar to an ownership permission.…It allows the user assigned this permission, to grant permissions to other…users for the specific securable on which this permission has been applied.…
It's important to note that with this permission type, any principal that is…assigned the control can grant permissions to the object in which they have control.…Which means you relinquish some of your control…over the amount of security applied to the objects.…This permission also cascades down to all…objects in the scope.…As a result, assigning the control permission to a user for a schema in the…
- Understanding security best practices
- Managing logins and users
- Understanding how SQL Server checks permissions
- Creating and assigning logins and roles
- Securing SQL on the network