Join Gerry O'Brien for an in-depth discussion in this video Understanding and using roles, part of Securing SQL Server 2012.
To aid in providing a flexible and manageable security…architecture, SQL Server offers a concept of a role.…SQL Server roles allow you to group user or logins into a…specific container for assigning permissions to…securables on your SQL Server instance.…Permissions assigned to a role are applied to any…user or login that is associated with that role.…SQL Server provides…nine fixed server roles.…We can locate these server roles by expanding the Security folder…of our SQL Server instance, and then expanding the Server Roles folder.…
Note that these server roles are included for backward compatibility…and you cannot change the fixed server permissions for these roles.…However, SQL Server 2012 does allow you to create a…new server role in which case you can name the server…role, specify the securables to which it will apply.…Add members to the role, or ensure that the role has a membership in another fixed…server role, which allows you to control the security for this user-defined role.…Let's have a look at the nine fixed…
- 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