Partilhar via


ServerPermission Members

The ServerPermission object represents a Microsoft SQL Server server-level permission.

The following tables list the members exposed by the ServerPermission type.

Public Properties

  Name Description
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AdministerBulkOperations Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyConnection Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyCredential Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyDatabase Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyEndpoint Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyEventNotification Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyLinkedServer Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterAnyLogin Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterResources Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterServerState Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterSettings Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AlterTrace Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif AuthenticateServer Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ConnectSql Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ControlServer Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif CreateAnyDatabase Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif CreateDdlEventNotification Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif CreateEndpoint Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif CreateTraceEventNotification Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ExternalAccessAssembly Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif Shutdown Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif UnsafeAssembly Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ViewAnyDatabase Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ViewAnyDefinition Gets a permission that can be included in the server permission set.
ms220231.pubproperty(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ViewServerState Gets a permission that can be included in the server permission set.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif Add Returns a set of server permissions after adding a new server permission to an existing set of server permissions.
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif BitwiseOr  
ms220231.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms220231.pubmethod(en-US,SQL.90).gif GetHashCode Overridden. This method supports the Microsoft SQL Server 2005 infrastructure and is not intended to be used directly from your code.
ms220231.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif op_Addition Creates a server permission set by performing an addition operation on two ServerPermission objects.
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif op_BitwiseOr Creates a server permission set by performing a bitwise OR operation on two ServerPermission objects.
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif op_Equality Creates a server permission set by performing an equality operation on two ServerPermission objects.
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif op_Implicit  
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif op_Inequality Creates a server permission set by performing an inequality operation on two ServerPermission objects.
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220231.pubmethod(en-US,SQL.90).gifms220231.static(en-US,SQL.90).gif ToServerPermissionSet Returns a set of server permissions based on a single server permission, by converting a ServerPermission object to a ServerPermissionSet object.
ms220231.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms220231.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220231.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

ServerPermission Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Granting, Revoking, and Denying Permissions
Permissions
sys.server_permissions (Transact-SQL)