FixedServerRoles-Enumeration

The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.

Diese Enumeration verfügt über ein FlagsAttribute-Attribut, das die bitweise Kombination der Elementwerte zulässt.

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

Elemente

Elementname Beschreibung
None No server role.
SysAdmin Can control any aspect of the instance of Microsoft SQL Server.
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.
SecurityAdmin Can alter logons.
ProcessAdmin Can alter connections.
DBCreator Can create databases.
DiskAdmin Can alter resources.
BulkAdmin Administers bulk operations.

Hinweise

The FixedServerRoles class is served by the ServerConnection class.