ServerPermissionSet Members

The ServerPermissionSet object represents a set of server permissions.

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

Public Constructors

  Name Description
ServerPermissionSet Overloaded. Initializes a new instance of the ServerPermissionSet class.

Top

Public Properties

  Name Description
ms220185.pubproperty(en-US,SQL.90).gif AdministerBulkOperations Gets or sets the Boolean property value that specifies whether to include the ADMINISTER BULK OPERATIONS (ADBO) permission in the permission set. This permission lets the grantee perform bulk insert operations on the instance of SQL Server, such as importing data by using the bcp command, using the BULK INSERT statement, or using the INSERT…SELECT * FROM OPENROWSET(BULK…) statement.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyConnection Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CONNECTION (ALCO) permission in the permission set. This permission lets the grantee create, alter, or drop any connection on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyCredential Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CREDENTIAL (ALCD) permission in the permission set. This permission lets the grantee create, alter, or drop any credential on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyDatabase Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE (ALDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyEndpoint Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ENDPOINT (ALHE) permission in the permission set. This permission lets the grantee create, alter, or drop any endpoint on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyEventNotification Gets or sets the Boolean property value that specifies whether to include the ALTER ANY EVENT NOTIFICATION (ALES) permission in the permission set. This permission lets the grantee to create, alter, or drop any event notification on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyLinkedServer Gets or sets the Boolean property value that specifies whether to include the ALTER ANY LINKED SERVER (ALLS) permission in the permission set. This permission lets the grantee create, alter, or drop any linked server on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterAnyLogin Gets or sets the Boolean property value that specifies whether to include the ALTER ANY LOGIN (ALLG) permission in the permission set. This permission lets the grantee create, alter, or drop any linked server on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterResources Gets or sets the Boolean property value that specifies whether to include the ALTER RESOURCES (ALRS) permission in the permission set. This permission lets the grantee create, alter, or drop any resource on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterServerState Gets or sets the Boolean property value that specifies whether to include the ALTER SERVER STATE (ALSS) permission in the permission set. This permission lets the grantee stop, start, or pause the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AlterSettings Gets or sets the Boolean property value that specifies whether to include the ALTER SETTINGS (ASLT) permission in the permission set. This permission lets the grantee alter any settings on the instance of SQL Server, such as the default database directory.
ms220185.pubproperty(en-US,SQL.90).gif AlterTrace Gets or sets the Boolean property value that specifies whether to include the ALTER TRACE (ALTR) permission in the permission set. This permission lets the grantee start, or stop trace runs or modify the trace options on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif AuthenticateServer Gets or sets the Boolean property value that specifies whether to include the AUTHENTICATE SERVER permission in the permission set. This permission lets the grantee authenticate users on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif ConnectSql Gets or sets the Boolean property value that specifies whether to include the CONNECT SQL (COSQ) permission in the permission set. This permission lets the grantee connect to the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif ControlServer Gets or sets the Boolean property value that specifies whether to include the CONTROL SERVER (CL) permission in the permission set. This permission lets the grantee grant any permission on any securable on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif CreateAnyDatabase Gets or sets the Boolean property value that specifies whether to include the CREATE ANY DATABASE (CRDB) permission in the permission set. This permission lets the grantee create, alter, or drop any database on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif CreateDdlEventNotification Gets or sets the Boolean property value that specifies whether to include the CREATE DDL EVENT NOTIFICATION (CRDE) permission in the permission set. This permission lets the grantee create any DDL (Data Definition Language) event notification on the instance of SQL Server, such as the event that is raised when a database is created.
ms220185.pubproperty(en-US,SQL.90).gif CreateEndpoint Gets or sets the Boolean property value that specifies whether to include the CREATE ENDPOINT (CRHE) permission in the permission set. This permission lets the grantee create endpoints on the instance of SQL Server for SOAP, Transact-SQL, database mirroring, and Service Broker.
ms220185.pubproperty(en-US,SQL.90).gif CreateTraceEventNotification Gets or sets the Boolean property value that specifies whether to include the CREATE TRACE EVENT NOTIFICATION (CRTE) permission in the permission set. This permission lets the grantee create trace event notifications on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif 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.
ms220185.pubproperty(en-US,SQL.90).gif Shutdown Gets or sets the Boolean property value that specifies whether to include the SHUTDOWN (SHDN) permission in the permission set. This permission lets the grantee stop the SQL Server service.
ms220185.pubproperty(en-US,SQL.90).gif 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
ms220185.pubproperty(en-US,SQL.90).gif ViewAnyDatabase Gets or sets the Boolean property value that specifies whether to include the VIEW ANY DATABASE (VWDB) permission in the permission set. This permission lets the grantee view the definition (metadata) of any database on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif ViewAnyDefinition Gets or sets the Boolean property value that specifies whether to include the VIEW ANY DEFINITION (VWAD) permission in the permission set. This permission lets the grantee view the definition of any server that is securable on the instance of SQL Server.
ms220185.pubproperty(en-US,SQL.90).gif ViewServerState Gets or sets the Boolean property value that specifies whether to include the VIEW SERVER STATE (VWSS) permission in the permission set. This permission lets the grantee view the state of the instance of SQL Server.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220185.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a server permission set after adding a new server permission to the permission set.
ms220185.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms220185.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.
ms220185.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif op_Addition Creates a server permission set by performing an addition operation on a ServerPermission object and a ServerPermissionSet object.
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif op_Equality Determines whether two objects are equal by performing an equality operation on two ServerPermissionSet objects.
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif op_Inequality Determines whether two objects are unequal by performing an inequality operation on two ServerPermissionSet objects.
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif op_Subtraction Creates a server permission set by performing a subtraction operation on a ServerPermission object and a ServerPermissionSet object.
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220185.pubmethod(en-US,SQL.90).gif Remove Removes a permission from the permission set.
ms220185.pubmethod(en-US,SQL.90).gifms220185.static(en-US,SQL.90).gif Subtract Returns a server permission set after subtracting a server permission from the specified permission set.
ms220185.pubmethod(en-US,SQL.90).gif ToString  Returns the string value that represents the specified PermissionSetBase object. (inherited from PermissionSetBase)

Top

Protected Methods

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

Top

See Also

Reference

ServerPermissionSet Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

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