O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Image

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required