共用方式為


ServerPermissionSetValue 列舉

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

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.SqlEnum (在 Microsoft.SqlServer.SqlEnum.dll 中)

語法

'宣告
Public Enumeration ServerPermissionSetValue
'用途
Dim instance As ServerPermissionSetValue
public enum ServerPermissionSetValue
public enum class ServerPermissionSetValue
type ServerPermissionSetValue
public enum ServerPermissionSetValue

成員

成員名稱 說明
AdministerBulkOperations The ability to administer bulk operations.
AlterAnyAvailabilityGroup The ability to alter any available group.
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.
AlterAnyEventSession The ability to alter any event session.
AlterAnyLinkedServer The ability to alter any linked server.
AlterAnyLogin The ability to alter any login.
AlterAnyServerAudit The ability to alter any server audit.
AlterAnyServerRole The ability to alter any server role.
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.
CreateAvailabilityGroup The ability to create availability group.
CreateDdlEventNotification The ability to create data definition language (DDL) event notifications.
CreateEndpoint The ability to create endpoints.
CreateServerRole The ability to create any server role.
CreateTraceEventNotification The ability to create trace event notifications.
ExternalAccessAssembly Gets or sets the Boolean property value that specifies whether to include the EXTERNAL ACCESS (XA) permission in the permission set. This permission lets the grantee access external system resources such as assembly files, networks, environmental variables, and the registry.
Shutdown The ability to shut down the server.
UnsafeAssembly Gets or sets the Boolean property value that specifies whether to include the UNSAFE permission in the permission set. This permission allows the grantee unrestricted access to resources, both within and outside SQL Server, including calls to unmanaged code
ViewAnyDatabase The ability to view any database.
ViewAnyDefinition The ability to view any definition.
ViewServerState The ability to view the state of the server.

範例

授與、撤銷和拒絕權限

請參閱

參考

Microsoft.SqlServer.Management.Smo 命名空間