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 15.3 lists the fixed database roles and their permissions.


TABLE 15.3 Fixed Database Roles


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 2014 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.