• Article

Classe DatabasePermission

The DatabasePermission object represents a SQL Server database permission. The database permission can be added to a database permission set, and then granted, revoked, or denied to a user.

Hiérarchie d'héritage

System. . :: . .Object
  Microsoft.SqlServer.Management.Smo..::..DatabasePermission

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public NotInheritable Class DatabasePermission
'Utilisation
Dim instance As DatabasePermission

public sealed class DatabasePermission

public ref class DatabasePermission sealed

[<SealedAttribute>]
type DatabasePermission =  class end

public final class DatabasePermission

Le type DatabasePermission expose les membres suivants.

Propriétés

  Nom Description
Propriété publiqueMembre statique Alter Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyApplicationRole Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyAssembly Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyAsymmetricKey Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyCertificate Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyContract Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyDatabaseAudit Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyDatabaseDdlTrigger Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyDatabaseEventNotification Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyDataspace Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyFulltextCatalog Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyMessageType Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyRemoteServiceBinding Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyRole Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyRoute Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnySchema Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyService Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnySymmetricKey Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique AlterAnyUser Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Authenticate Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique BackupDatabase Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique BackupLog Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Checkpoint Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Connect Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique ConnectReplication Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Control Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateAggregate Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateAssembly Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateAsymmetricKey Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateCertificate Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateContract Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateDatabase Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateDatabaseDdlEventNotification Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateDefault Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateFulltextCatalog Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateFunction Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateMessageType Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateProcedure Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateQueue Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateRemoteServiceBinding Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateRole Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateRoute Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateRule Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateSchema Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateService Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateSymmetricKey Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateSynonym Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateTable Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateType Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateView Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique CreateXmlSchemaCollection Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Delete Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Execute Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Insert Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique References Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Select Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Showplan Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique SubscribeQueryNotifications Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique TakeOwnership Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique Update Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique ViewDatabaseState Gets a permission that can be included in the database permission set.
Propriété publiqueMembre statique ViewDefinition Gets a permission that can be included in the database permission set.

Haut de la page

Méthodes

  Nom Description
Méthode publiqueMembre statique Add Returns a set of database permissions after adding a new database permission to an existing set of database permissions.
Méthode publiqueMembre statique BitwiseOr Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
Méthode publique Equals Determines whether the referenced database permission object is equal to a specified object. (remplace Object. . :: . .Equals(Object).)
Méthode protégée Finalize (hérité de Object.)
Méthode publique GetHashCode This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (remplace Object. . :: . .GetHashCode() () () ().)
Méthode publique GetType (hérité de Object.)
Méthode protégée MemberwiseClone (hérité de Object.)
Méthode publiqueMembre statique ToDatabasePermissionSet Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object.
Méthode publique ToString (hérité de Object.)

Haut de la page

Opérateurs

  Nom Description
Opérateur publicMembre statique Addition Creates a database permission set by performing an addition operation on two DatabasePermission objects.
Opérateur publicMembre statique BitwiseOr Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects.
Opérateur publicMembre statique Equality Compares two DatabasePermission objects in an equality operation.
Opérateur publicMembre statique Implicit Widening Implicit Implicit Implicit(DatabasePermission to DatabasePermissionSet) Converts a single database permission object to a database permission set.
Opérateur publicMembre statique Inequality Determines whether two DatabasePermission objects are not equal by performing an inequality operation.

Haut de la page

Notes

Database permissions are required when running granting, denying, or revoking permissions on a database. The DatabasePermission object is used to specify the set of permissions that apply to the Grant, Deny, and Revoke methods of the Database object. Also, database permissions can be added to the DatabasePermissionSet object, which can also be used with the Grant, Deny, and Revoke methods.

Thread Safety

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.