Join Gerry O'Brien for an in-depth discussion in this video Creating roles, part of Securing SQL Server 2012.
As you recall from our lesson on understanding roles,…the roles within SQL Server provide a container for permissions.…Assigning permissions to the roles and then assigning log…ins or database users to these roles, permits you…to manage permissions for multiple users without the need…to set individual permissions for each log in seperately.…Once again, there are built-in roles in SQL Server,…as well as user-defined roles that you can create.…Let's do a quick review of the built-in roles in SQL Server.…At the Server level, expanding the Security…folder, and expanding the Server Roles folder, will…list all of the available built-in server…roles that SQL Server makes available for us.…
Again remember that these built in roles were included for backward…compatibility, and the permissions on these built in roles cannot be changed.…Therefore, it's important for you to understand what permissions…these specific roles have.…The lesson on understanding roles includes a topic on explaining…what the permissions are for each one of these server roles.…
- 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