Some of the SQL Server fixed server roles : Role « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. Role
Role            Description
sysadmin        Can perform any activity on the server.
securityadmin   Can manage login IDs and passwords for the server.
dbcreator       Can create, alter, and drop databases.








28.9.Role
28.9.1.Some of the SQL Server fixed server roles
28.9.2.Managing Server Role Members
28.9.3.Reporting Fixed Server Role Information
28.9.4.Managing User-Defined Database Roles: grant
28.9.5.Managing User-Defined Database Roles: alter role
28.9.6.Managing User-Defined Database Roles: drop role
28.9.7.Managing Application Roles
28.9.8.Managing Fixed Database Role Membership: sp_droprolemember
28.9.9.Managing User-Defined Database Roles: Create
28.9.10.Reporting Fixed Database Roles Information
28.9.11.Managing Fixed Database Role Membership: sp_addrolemember