Export (0) Print
Expand All

DatabasePermissionSet Members

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

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

  Name Description
DatabasePermissionSet Overloaded. Initializes a new instance of the DatabasePermissionSet class.
Top

  Name Description
ms219473.pubproperty(en-US,SQL.90).gif Alter 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyApplicationRole 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyAssembly 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyAsymmetricKey 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyCertificate 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyContract 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyDatabaseDdlTrigger 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyDatabaseEventNotification 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyDataspace 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyFulltextCatalog 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyMessageType 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyRemoteServiceBinding 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyRole 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyRoute 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnySchema 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyService 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnySymmetricKey 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.
ms219473.pubproperty(en-US,SQL.90).gif AlterAnyUser 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.
ms219473.pubproperty(en-US,SQL.90).gif Authenticate 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.
ms219473.pubproperty(en-US,SQL.90).gif BackupDatabase 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.
ms219473.pubproperty(en-US,SQL.90).gif BackupLog 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.
ms219473.pubproperty(en-US,SQL.90).gif Checkpoint 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.
ms219473.pubproperty(en-US,SQL.90).gif Connect 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.
ms219473.pubproperty(en-US,SQL.90).gif ConnectReplication 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.
ms219473.pubproperty(en-US,SQL.90).gif Control 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateAggregate 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateAssembly 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateAsymmetricKey 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateCertificate 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateContract 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateDatabase 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateDatabaseDdlEventNotification 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateDefault 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateFulltextCatalog 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateFunction Gets or sets the Boolean property value that specifies wh This permission lets the grantee create a function in the database.
ms219473.pubproperty(en-US,SQL.90).gif CreateMessageType 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateProcedure 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateQueue 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateRemoteServiceBinding 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateRole 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateRoute 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateRule 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateSchema 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateService 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateSymmetricKey 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateSynonym 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateTable 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateType 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 change create a type in the database.
ms219473.pubproperty(en-US,SQL.90).gif CreateView 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.
ms219473.pubproperty(en-US,SQL.90).gif CreateXmlSchemaCollection 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.
ms219473.pubproperty(en-US,SQL.90).gif Delete 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.
ms219473.pubproperty(en-US,SQL.90).gif Execute 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.
ms219473.pubproperty(en-US,SQL.90).gif Insert 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.
ms219473.pubproperty(en-US,SQL.90).gif References 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.
ms219473.pubproperty(en-US,SQL.90).gif Select 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.
ms219473.pubproperty(en-US,SQL.90).gif Showplan 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.
ms219473.pubproperty(en-US,SQL.90).gif SubscribeQueryNotifications 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.
ms219473.pubproperty(en-US,SQL.90).gif TakeOwnership 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.
ms219473.pubproperty(en-US,SQL.90).gif Update 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.
ms219473.pubproperty(en-US,SQL.90).gif ViewDatabaseState 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.
ms219473.pubproperty(en-US,SQL.90).gif ViewDefinition 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.
Top

(see also Protected Methods )
  Name Description
ms219473.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a database permission set after adding a new a database permission to the permission set.
ms219473.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms219473.pubmethod(en-US,SQL.90).gif GetHashCode Overridden. This method supports the SQL Server 2005 infrastructure and is not intended to be used directly from your code.
ms219473.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif op_Addition Creates a database permission set by performing an addition operation on a DatabasePermission object and a DatabasePermissionSet object.
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif op_Equality  
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif op_Inequality Determines whether two objects are unequal by performing an inequality operation on two DatabasePermissionSet objects.
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif op_Subtraction Creates a database permission set by performing a subtraction operation on a DatabasePermission object and a DatabasePermissionSet object.
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219473.pubmethod(en-US,SQL.90).gif Remove Removes a permission from the permission set.
ms219473.pubmethod(en-US,SQL.90).gif ms219473.static(en-US,SQL.90).gif Subtract Returns a database permission set after removing a database permission from the specified permission set.
ms219473.pubmethod(en-US,SQL.90).gif ToString  Returns the string value that represents the specified PermissionSetBase object. (inherited from PermissionSetBase)
Top

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

Community Additions

ADD
Show:
© 2014 Microsoft