Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.
ExternalAccessAssembly 
ShutdownThe ability to shut down the server.
UnsafeAssembly 
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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.