Compartilhar via


Classe DatabasePermissionSet

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

Hierarquia de herança

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

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

Sintaxe

'Declaração
Public NotInheritable Class DatabasePermissionSet _
    Inherits PermissionSetBase
'Uso
Dim instance As DatabasePermissionSet
public sealed class DatabasePermissionSet : PermissionSetBase
public ref class DatabasePermissionSet sealed : public PermissionSetBase
[<SealedAttribute>]
type DatabasePermissionSet =  
    class 
        inherit PermissionSetBase 
    end
public final class DatabasePermissionSet extends PermissionSetBase

O tipo DatabasePermissionSet expõe os membros a seguir.

Construtores

  Nome Descrição
Método público DatabasePermissionSet() Initializes a new instance of the DatabasePermissionSet class.
Método público DatabasePermissionSet(DatabasePermission) Initializes a new instance of the DatabasePermissionSet class.
Método público DatabasePermissionSet(array<DatabasePermission[]) Initializes a new instance of the DatabasePermissionSet class.
Método público DatabasePermissionSet(DatabasePermissionSet) Initializes a new instance of the DatabasePermissionSet class.

Início

Propriedades

  Nome Descrição
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública AlterAnyDatabaseAudit 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública CreateFunction 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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 create a type in the database.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.
Propriedade pública 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.

Início

Métodos

  Nome Descrição
Método público Add(DatabasePermission) Returns a database permission set after adding a new a database permission to the referenced permission set.
Método públicoMembro estático Add(DatabasePermissionSet, DatabasePermission) Returns a database permission set after adding a new a database permission to the specified permission set.
Método público Equals Determines whether the referenced database permission object is equal to a specified object. (Substitui PermissionSetBase.Equals(Object).)
Método público GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Substitui PermissionSetBase.GetHashCode().)
Método público GetType (Herdado de Object.)
Método público Remove Removes a permission from the permission set.
Método públicoMembro estático Subtract Returns a database permission set after removing a database permission from the specified permission set.
Método público ToString Returns the string value that represents the specified PermissionSetBase object. (Herdado de PermissionSetBase.)

Início

Operadores

  Nome Descrição
Operador públicoMembro estático Addition Creates a database permission set by performing an addition operation on a DatabasePermission object and a DatabasePermissionSet object.
Operador públicoMembro estático Equality Determines whether two DatabasePermissionSet objects are equal.
Operador públicoMembro estático Inequality Determines whether two objects are unequal by performing an inequality operation on two DatabasePermissionSet objects.
Operador públicoMembro estático Subtraction Creates a database permission set by performing a subtraction operation on a DatabasePermission object and a DatabasePermissionSet object.

Início

Comentários

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.

Thread Safety

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Exemplos

Concedendo, revogando e negando permissões

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Permissões (Mecanismo de Banco de Dados)