Database Engine Fixed Server and Fixed Database Roles

Database Engine Fixed Server and Fixed Database Roles

Fixed server roles and fixed database roles are assigned specific permissions by SQL Server. The permissions of the fixed roles cannot be changed. Fixed server and fixed database roles are provided for convenience and backward compatibility. Beginning with SQL Server 2005, a more granular permission system is available. Microsoft recommends that you assign the more specific permissions whenever possible.

Fixed Server Roles

The following illustration shows the permissions held by the fixed server roles.

Important The ability to grant access to the Database Engine and to configure user permissions allows the security admin to assign most server permissions. The securityadmin role should be treated as equivalent to the sysadmin role.

 

Fixed Database Roles

The following illustration shows the permissions held by the fixed database roles.

Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (1 items)