Do you like Roles? Do you want to know a little more about SQL Server's built in Roles and what they do? Do you want to know some nifty built in sprocs that also give some extra info about the Roles?
Then this is a post for you!
Firstly let us look briefly at SQL Server's nine (9) built in Roles:
- SysAdmin - This is the big guy. Members of this Role have all the permissions across the instance. A SysAdmin is specified during installation.
- ServerAdmin - Members of this Role are allowed to perform instance configuration tasks and can also stop an instance.
- SecurityAdmin - Members can alter and elevate permissions for Logins. Can elevate permissions to SysAdmin.
- ProcessAdmin - Members can stop instance processes.
- SetupAdmin - Members can add/remove DBs to linked servers.
- BulkAdmin - Members can bulk insert.
- DiskAdmin - Members can perform tasks involving instance related files.
- DBCreator - Members can add/drop/alter/restore databases on an instance.
- Public - The little guy. All logins are considered part of the public Role group. Not a 'real' built in role.
