ServerPermissionSetValue Enumeration

The ServerPermissionSetValue enumeration is a list of constant values that specify all the database permissions.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in microsoft.sqlserver.sqlenum.dll)

public enum ServerPermissionSetValue
public enum ServerPermissionSetValue
public enum ServerPermissionSetValue

Member nameDescription
AdministerBulkOperationsThe ability to administer bulk operations.
AlterAnyConnectionThe ability to alter any connection.
AlterAnyCredentialThe ability to alter any credential.
AlterAnyDatabaseThe ability to alter any database.
AlterAnyEndpointThe ability to alter any endpoint.
AlterAnyEventNotificationThe ability to alter any event notification.
AlterAnyLinkedServerThe ability to alter any linked server.
AlterAnyLoginThe ability to alter any login.
AlterResourcesThe ability to alter resources.
AlterServerStateThe ability to alter the state of the server.
AlterSettingsThe ability to alter settings.
AlterTraceThe ability to alter traces.
AuthenticateServerThe ability to authenticate the server.
ConnectSqlThe ability to connect to SQL Server.
ControlServerThe ability to control the server.
CreateAnyDatabaseThe ability to create any database.
CreateDdlEventNotificationThe ability to create data definition language (DDL) event notifications.
CreateEndpointThe ability to create endpoints.
CreateTraceEventNotificationThe ability to create trace event notifications.
ShutdownThe ability to shut down the server.
ViewAnyDatabaseThe ability to view any database.
ViewAnyDefinitionThe ability to view any definition.
ViewServerStateThe ability to view the state of the server.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions