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.
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 ...