SQL Server roles
Recently I was asked the question - what is the difference between Standard Server roles and Fixed server roles.I know Fixed Server roles include Sysadmin, Securityadmin, etc. But, I am not sure about Standard server roles. Thank you.
What are the different SQL Server roles? Here is a list of different roles in SQL Server?
- Sysadmin - can perform any activity in the server
- Serveradmin - can change server-wide configuration options and shut down the server
- Securityadmin - manage logins and their properties. They can GRANT, DENY or REVOKE database-level permissions. They can even reset passwords for SQL server login.
- Processadmin - can end processes that are running in an instance of SQL Server
- Setupadmin - can add and remove linked servers
- Bulkadmin - can run the BULK INSERT statement
- Diskadmin - for managing disk files
- Dbcreator - can create, alter, drop, and restore any database.
- public:
- Every SQL Server login belongs to the public server role. When a server principal has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to the public on that object. Only assign public permissions on any object when you want the object to be available to all users.