This topic has not yet been rated - Rate this topic

ServerPermissionSetValue Enumeration

SQL Server 2005

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)

Copy

public enum ServerPermissionSetValue

Copy

public enum ServerPermissionSetValue

Copy

public enum ServerPermissionSetValue

Member name	Description
AdministerBulkOperations	The ability to administer bulk operations.
AlterAnyConnection	The ability to alter any connection.
AlterAnyCredential	The ability to alter any credential.
AlterAnyDatabase	The ability to alter any database.
AlterAnyEndpoint	The ability to alter any endpoint.
AlterAnyEventNotification	The ability to alter any event notification.
AlterAnyLinkedServer	The ability to alter any linked server.
AlterAnyLogin	The ability to alter any login.
AlterResources	The ability to alter resources.
AlterServerState	The ability to alter the state of the server.
AlterSettings	The ability to alter settings.
AlterTrace	The ability to alter traces.
AuthenticateServer	The ability to authenticate the server.
ConnectSql	The ability to connect to SQL Server.
ControlServer	The ability to control the server.
CreateAnyDatabase	The ability to create any database.
CreateDdlEventNotification	The ability to create data definition language (DDL) event notifications.
CreateEndpoint	The ability to create endpoints.
CreateTraceEventNotification	The ability to create trace event notifications.
ExternalAccessAssembly
Shutdown	The ability to shut down the server.
UnsafeAssembly
ViewAnyDatabase	The ability to view any database.
ViewAnyDefinition	The ability to view any definition.
ViewServerState	The 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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ