FixedServerRoles Enumeration
The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Namespace: Microsoft.SqlServer.Management.Common
Assembly: Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)
Syntax
'Declaration
<FlagsAttribute> _
Public Enumeration FixedServerRoles
'Usage
Dim instance As FixedServerRoles
[FlagsAttribute]
public enum FixedServerRoles
[FlagsAttribute]
public enum class FixedServerRoles
[<FlagsAttribute>]
type FixedServerRoles
public enum FixedServerRoles
Members
| Member name | Description | |
|---|---|---|
| BulkAdmin | Administers bulk operations. | |
| DBCreator | Can create databases. | |
| DiskAdmin | Can alter resources. | |
| None | No server role. | |
| ProcessAdmin | Can alter connections. | |
| SecurityAdmin | Can alter logons. | |
| ServerAdmin | Can alter Microsoft SQL Server settings, shut down the SQL Server Service, create and alter endpoints, alter the SQL Server state, and alter resources. | |
| SetupAdmin | Can alter linked servers. | |
| SysAdmin | Can control any aspect of the instance of Microsoft SQL Server. |
Remarks
The FixedServerRoles class is served by the ServerConnection class.
See Also
Reference
Microsoft.SqlServer.Management.Common Namespace