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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
