Export (0) Print
Expand All

DatabasePermissionSet Class

 

Applies To: SQL Server 2016 Preview

The DatabasePermissionSet object represents a SQL Server set of database permissions.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

System.Object
  Microsoft.SqlServer.Management.Smo.PermissionSetBase
    Microsoft.SqlServer.Management.Smo.DatabasePermissionSet

public sealed class DatabasePermissionSet : PermissionSetBase

NameDescription
System_CAPS_pubmethodDatabasePermissionSet()

Initializes a new instance of the DatabasePermissionSet class.

System_CAPS_pubmethodDatabasePermissionSet(DatabasePermission)

Initializes a new instance of the DatabasePermissionSet class.

System_CAPS_pubmethodDatabasePermissionSet(DatabasePermission[])

Initializes a new instance of the DatabasePermissionSet class.

System_CAPS_pubmethodDatabasePermissionSet(DatabasePermissionSet)

Initializes a new instance of the DatabasePermissionSet class.

NameDescription
System_CAPS_pubpropertyAlter

Gets or sets the Boolean property value that specifies whether to include the ALTER permission in the permission set. This permission lets the grantee change the properties of the database, except ownership, and create, alter, or drop any child objects.

System_CAPS_pubpropertyAlterAnyApplicationRole

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY APPLICATION ROLE permission in the permission set. This permission lets the grantee change the properties of any application role in the database, except ownership.

System_CAPS_pubpropertyAlterAnyAssembly

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ASSEMBLY permission in the permission set. This permission lets the grantee change the properties of any assembly in the database, except ownership.

System_CAPS_pubpropertyAlterAnyAsymmetricKey

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ASYMMETRIC KEY permission in the permission set. This permission lets the grantee change the properties of any asymmetric key in the database, except ownership.

System_CAPS_pubpropertyAlterAnyCertificate

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CERTIFICATE permission in the permission set. This permission lets the grantee change the properties of any in the certificate in the database, except ownership.

System_CAPS_pubpropertyAlterAnyContract

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY CONTRACT permission in the permission set. This permission lets the grantee change the properties of any Service Broker contract in the database, except ownership.

System_CAPS_pubpropertyAlterAnyDatabaseAudit

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE AUDIT permission in the permission set. This permission lets the grantee change modify the database audit objects.

System_CAPS_pubpropertyAlterAnyDatabaseDdlTrigger

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE DDL TRIGGER permission in the permission set. This permission lets the grantee change the properties of any database DDL trigger in the database, except ownership.

System_CAPS_pubpropertyAlterAnyDatabaseEventNotification

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATABASE EVENT NOTIFICATION permission in the permission set. This permission lets the grantee change the properties of any database event notification in the database, except ownership.

System_CAPS_pubpropertyAlterAnyDataspace

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY DATASPACE permission in the permission set. This permission lets the grantee change modify the database files.

System_CAPS_pubpropertyAlterAnyFulltextCatalog

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY FULL TEXT CATALOG permission in the permission set. This permission lets the grantee change the properties of any Full Text catalog in the database, except ownership.

System_CAPS_pubpropertyAlterAnyMessageType

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY MESSAGE TYPE permission in the permission set. This permission lets the grantee change the properties of any message type in the database, except ownership.

System_CAPS_pubpropertyAlterAnyRemoteServiceBinding

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY REMOTE SERVICE BINDING permission in the permission set. This permission lets the grantee change the properties of any remote service binding in the database, except ownership.

System_CAPS_pubpropertyAlterAnyRole

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ROLE permission in the permission set. This permission lets the grantee change the properties of any role in the database, except ownership.

System_CAPS_pubpropertyAlterAnyRoute

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY ROUTE permission in the permission set. This permission lets the grantee change the properties of any Service Broker route in the database, except ownership.

System_CAPS_pubpropertyAlterAnySchema

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY SCHEMA permission in the permission set. This permission lets the grantee change the properties of any schema in the database, except ownership.

System_CAPS_pubpropertyAlterAnyService

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY SERVICE permission in the permission set. This permission lets the grantee change the properties of any Service Broker service in the database, except ownership.

System_CAPS_pubpropertyAlterAnySymmetricKey

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY SYMMETRIC KEY permission in the permission set. This permission lets the grantee change the properties of any symmetric key in the database, except ownership.

System_CAPS_pubpropertyAlterAnyUser

Gets or sets the Boolean property value that specifies whether to include the ALTER ANY USER permission in the permission set. This permission lets the grantee change the properties of any user in the database, except ownership.

System_CAPS_pubpropertyAuthenticate

Gets or sets the Boolean property value that specifies whether to include the AUTHENTICATE permission in the permission set. This permission lets the grantee authenticate the database.

System_CAPS_pubpropertyBackupDatabase

Gets or sets the Boolean property value that specifies whether to include the BACKUP DATABASE permission in the permission set. This permission lets the grantee create a backup of the database.

System_CAPS_pubpropertyBackupLog

Gets or sets the Boolean property value that specifies whether to include the BACKUP LOG permission in the permission set. This permission lets the grantee create a backup of the transaction log.

System_CAPS_pubpropertyCheckpoint

Gets or sets the Boolean property value that specifies whether to include the CHECKPOINT permission in the permission set. This permission lets the grantee issue a checkpoint on the database.

System_CAPS_pubpropertyConnect

Gets or sets the Boolean property value that specifies whether to include the CONNECT permission in the permission set. This permission lets the grantee connect to the database.

System_CAPS_pubpropertyConnectReplication

Gets or sets the Boolean property value that specifies whether to include the CONNECT REPLICATION permission in the permission set. This permission lets the grantee connect to replication databases.

System_CAPS_pubpropertyControl

Gets or sets the Boolean property value that specifies whether to include the CONTROL permission in the permission set. This permission gives the grantee full control over the database, which includes every database permission.

System_CAPS_pubpropertyCreateAggregate

Gets or sets the Boolean property value that specifies whether to include the CREATE AGGREGATE permission in the permission set. This permission lets the grantee create an aggregate in the database.

System_CAPS_pubpropertyCreateAssembly

Gets or sets the Boolean property value that specifies whether to include the CREATE ASSEMBLY permission in the permission set. This permission lets the grantee create an assembly in the database.

System_CAPS_pubpropertyCreateAsymmetricKey

Gets or sets the Boolean property value that specifies whether to include the CREATE ASYMMETRIC KEY permission in the permission set. This permission lets the grantee create an asymmetric key.

System_CAPS_pubpropertyCreateCertificate

Gets or sets the Boolean property value that specifies whether to include the CREATE CERTIFICATE permission in the permission set. This permission lets the grantee create a certificate in the database.

System_CAPS_pubpropertyCreateContract

Gets or sets the Boolean property value that specifies whether to include the CREATE CONTRACT permission in the permission set. This permission lets the grantee create a Service Broker contract.

System_CAPS_pubpropertyCreateDatabase

Gets or sets the Boolean property value that specifies whether to include the CREATE DATABASE permission in the permission set. This permission lets the grantee create the database.

System_CAPS_pubpropertyCreateDatabaseDdlEventNotification

Gets or sets the Boolean property value that specifies whether to include the CREATE DATABASE DDL EVENT NOTIFICATION permission in the permission set. This permission lets the grantee create a database DDL event notification.

System_CAPS_pubpropertyCreateDefault

Gets or sets the Boolean property value that specifies whether to include the CREATE DEFAULT permission in the permission set. This permission lets the grantee create a default in the database.

System_CAPS_pubpropertyCreateFulltextCatalog

Gets or sets the Boolean property value that specifies whether to include the CREATE FULL TEXT CATALOG permission in the permission set. This permission lets the grantee create a Full Text catalog in the database.

System_CAPS_pubpropertyCreateFunction

Gets or sets the Boolean property value that specifies whether to include the CREATE FUNCTION permission in the permission set. This permission lets the grantee create a function in the database.

System_CAPS_pubpropertyCreateMessageType

Gets or sets the Boolean property value that specifies whether to include the CREATE MESSAGE TYPE permission in the permission set. This permission lets the grantee create a message type in the database.

System_CAPS_pubpropertyCreateProcedure

Gets or sets the Boolean property value that specifies whether to include the CREATE PROCEDURE permission in the permission set. This permission lets the grantee create a stored procedure in the database.

System_CAPS_pubpropertyCreateQueue

Gets or sets the Boolean property value that specifies whether to include the CREATE QUEUE permission in the permission set. This permission lets the grantee create a Service Broker queue in the database.

System_CAPS_pubpropertyCreateRemoteServiceBinding

Gets or sets the Boolean property value that specifies whether to include the CREATE REMOTE SERVICE BINDING permission in the permission set. This permission lets the grantee create a remote service binding in the database.

System_CAPS_pubpropertyCreateRole

Gets or sets the Boolean property value that specifies whether to include the CREATE ROLE permission in the permission set. This permission lets the grantee create a database role.

System_CAPS_pubpropertyCreateRoute

Gets or sets the Boolean property value that specifies whether to include the CREATE ROUTE permission in the permission set. This permission lets the grantee create a Service Broker route in the database.

System_CAPS_pubpropertyCreateRule

Gets or sets the Boolean property value that specifies whether to include the CREATE RULE permission in the permission set. This permission lets the grantee create a rule in the database.

System_CAPS_pubpropertyCreateSchema

Gets or sets the Boolean property value that specifies whether to include the CREATE SCHEMA permission in the permission set. This permission lets the grantee create a schema in the database.

System_CAPS_pubpropertyCreateService

Gets or sets the Boolean property value that specifies whether to include the CREATE SERVICE permission in the permission set. This permission lets the grantee create a Service Broker service in the database.

System_CAPS_pubpropertyCreateSymmetricKey

Gets or sets the Boolean property value that specifies whether to include the CREATE SYMMETRIC KEY permission in the permission set. This permission lets the grantee create a symmetric key in the database.

System_CAPS_pubpropertyCreateSynonym

Gets or sets the Boolean property value that specifies whether to include the CREATE SYNONYM permission in the permission set. This permission lets the grantee create a synonym in the database.

System_CAPS_pubpropertyCreateTable

Gets or sets the Boolean property value that specifies whether to include the CREATE TABLE permission in the permission set. This permission lets the grantee create a table in the database.

System_CAPS_pubpropertyCreateType

Gets or sets the Boolean property value that specifies whether to include the CREATE TYPE permission in the permission set. This permission lets the grantee create a type in the database.

System_CAPS_pubpropertyCreateView

Gets or sets the Boolean property value that specifies whether to include the CREATE VIEW permission in the permission set. This permission lets the grantee create a view in the database.

System_CAPS_pubpropertyCreateXmlSchemaCollection

Gets or sets the Boolean property value that specifies whether to include the CREATE XML SCHEMA COLLECTION permission in the permission set. This permission lets the grantee create an XML schema collection in the database.

System_CAPS_pubpropertyDelete

Gets or sets the Boolean property value that specifies whether to include the DELETE permission in the permission set. This permission lets the grantee remove data from the database.

System_CAPS_pubpropertyExecute

Gets or sets the Boolean property value that specifies whether to include the EXECUTE permission in the permission set. This permission lets the grantee execute stored procedures and functions in the database.

System_CAPS_pubpropertyInsert

Gets or sets the Boolean property value that specifies whether to include the INSERT permission in the permission set. This permission lets the grantee add data to the database.

System_CAPS_pubpropertyReferences

Gets or sets the Boolean property value that specifies whether to include the REFERENCES permission in the permission set. This permission lets the grantee reference the database.

System_CAPS_pubpropertySelect

Gets or sets the Boolean property value that specifies whether to include the SELECT permission in the permission set. This permission lets the grantee retrieve data in the database.

System_CAPS_pubpropertyShowplan

Gets or sets the Boolean property value that specifies whether to include the SHOWPLAN permission in the permission set. This permission lets the grantee view the execution plan for stored procedures in the database.

System_CAPS_pubpropertySubscribeQueryNotifications

Gets or sets the Boolean property value that specifies whether to include the SUBSCRIBE QUERY NOTIFICATIONS permission in the permission set. This permission lets the grantee subscribe to Service Broker query notifications.

System_CAPS_pubpropertyTakeOwnership

Gets or sets the Boolean property value that specifies whether to include the TAKE OWNERSHIP permission in the permission set. This permission lets the grantee take ownership of the database.

System_CAPS_pubpropertyUpdate

Gets or sets the Boolean property value that specifies whether to include the UPDATE permission in the permission set. This permission lets the grantee update the data in the database.

System_CAPS_pubpropertyViewDatabaseState

Gets or sets the Boolean property value that specifies whether to include the VIEW DATABASE STATE permission in the permission set. This permission lets the grantee view the state of the database.

System_CAPS_pubpropertyViewDefinition

Gets or sets the Boolean property value that specifies whether to include the VIEW DEFINITION permission in the permission set. This permission lets the grantee view the metadata that defines the database.

NameDescription
System_CAPS_pubmethodAdd(DatabasePermission)

Returns a database permission set after adding a new a database permission to the referenced permission set.

System_CAPS_pubmethodSystem_CAPS_staticAdd(DatabasePermissionSet, DatabasePermission)

Returns a database permission set after adding a new a database permission to the specified permission set.

System_CAPS_pubmethodEquals(Object)

Determines whether the referenced database permission object is equal to a specified object.(Overrides PermissionSetBase.Equals(Object).)

System_CAPS_pubmethodGetHashCode()

This method supports the SQL Server infrastructure and is not intended to be used directly from your code.(Overrides PermissionSetBase.GetHashCode().)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(DatabasePermission)

Removes a permission from the permission set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(DatabasePermissionSet, DatabasePermission)

Returns a database permission set after removing a database permission from the specified permission set.

System_CAPS_pubmethodToString()

Returns the string value that represents the specified PermissionSetBase object.(Inherited from PermissionSetBase.)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(DatabasePermissionSet, DatabasePermission)

Creates a database permission set by performing an addition operation on a DatabasePermission object and a DatabasePermissionSet object.

System_CAPS_puboperatorSystem_CAPS_staticEquality(DatabasePermissionSet, DatabasePermissionSet)

Determines whether two DatabasePermissionSet objects are equal.

System_CAPS_puboperatorSystem_CAPS_staticInequality(DatabasePermissionSet, DatabasePermissionSet)

Determines whether two objects are unequal by performing an inequality operation on two DatabasePermissionSet objects.

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(DatabasePermissionSet, DatabasePermission)

Creates a database permission set by performing a subtraction operation on a DatabasePermission object and a DatabasePermissionSet object.

Database permissions are required when running granting, denying, or revoking permissions on a database. The DatabasePermissionSet object is required to specify the set of permissions that apply to the Grant method, the Deny method, and the Revoke method of the Database object.

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft