December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Fixed Database Roles
SQL Server provides fixed roles that define a common set of permissions at the database level. These fixed database roles are assigned to database users. The permissions defined for the fixed database roles cannot be changed. Table 17.3 shows the fixed database roles and their permissions.
TABLE 17.3 Fixed Database Roles
Note
You can find a more granular breakdown of permissions associated with fixed database roles by using the sp_dbfixedrolepermission. If you run this system procedure without any parameters, it returns a list of all the permissions for all the fixed database roles. You can also pass a specific fixed database ...