DatabasePermission-Klasse
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.
Vererbungshierarchie
System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..DatabasePermission
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public NotInheritable Class DatabasePermission
'Usage
Dim instance As DatabasePermission
public sealed class DatabasePermission
public ref class DatabasePermission sealed
[<SealedAttribute>]
type DatabasePermission = class end
public final class DatabasePermission
Der DatabasePermission-Typ macht folgende Elemente verfügbar.
Eigenschaften
Name | Beschreibung | |
---|---|---|
Alter | Gets a permission that can be included in the database permission set. | |
AlterAnyApplicationRole | Gets a permission that can be included in the database permission set. | |
AlterAnyAssembly | Gets a permission that can be included in the database permission set. | |
AlterAnyAsymmetricKey | Gets a permission that can be included in the database permission set. | |
AlterAnyCertificate | Gets a permission that can be included in the database permission set. | |
AlterAnyContract | Gets a permission that can be included in the database permission set. | |
AlterAnyDatabaseAudit | Gets a permission that can be included in the database permission set. | |
AlterAnyDatabaseDdlTrigger | Gets a permission that can be included in the database permission set. | |
AlterAnyDatabaseEventNotification | Gets a permission that can be included in the database permission set. | |
AlterAnyDataspace | Gets a permission that can be included in the database permission set. | |
AlterAnyFulltextCatalog | Gets a permission that can be included in the database permission set. | |
AlterAnyMessageType | Gets a permission that can be included in the database permission set. | |
AlterAnyRemoteServiceBinding | Gets a permission that can be included in the database permission set. | |
AlterAnyRole | Gets a permission that can be included in the database permission set. | |
AlterAnyRoute | Gets a permission that can be included in the database permission set. | |
AlterAnySchema | Gets a permission that can be included in the database permission set. | |
AlterAnyService | Gets a permission that can be included in the database permission set. | |
AlterAnySymmetricKey | Gets a permission that can be included in the database permission set. | |
AlterAnyUser | Gets a permission that can be included in the database permission set. | |
Authenticate | Gets a permission that can be included in the database permission set. | |
BackupDatabase | Gets a permission that can be included in the database permission set. | |
BackupLog | Gets a permission that can be included in the database permission set. | |
Checkpoint | Gets a permission that can be included in the database permission set. | |
Connect | Gets a permission that can be included in the database permission set. | |
ConnectReplication | Gets a permission that can be included in the database permission set. | |
Control | Gets a permission that can be included in the database permission set. | |
CreateAggregate | Gets a permission that can be included in the database permission set. | |
CreateAssembly | Gets a permission that can be included in the database permission set. | |
CreateAsymmetricKey | Gets a permission that can be included in the database permission set. | |
CreateCertificate | Gets a permission that can be included in the database permission set. | |
CreateContract | Gets a permission that can be included in the database permission set. | |
CreateDatabase | Gets a permission that can be included in the database permission set. | |
CreateDatabaseDdlEventNotification | Gets a permission that can be included in the database permission set. | |
CreateDefault | Gets a permission that can be included in the database permission set. | |
CreateFulltextCatalog | Gets a permission that can be included in the database permission set. | |
CreateFunction | Gets a permission that can be included in the database permission set. | |
CreateMessageType | Gets a permission that can be included in the database permission set. | |
CreateProcedure | Gets a permission that can be included in the database permission set. | |
CreateQueue | Gets a permission that can be included in the database permission set. | |
CreateRemoteServiceBinding | Gets a permission that can be included in the database permission set. | |
CreateRole | Gets a permission that can be included in the database permission set. | |
CreateRoute | Gets a permission that can be included in the database permission set. | |
CreateRule | Gets a permission that can be included in the database permission set. | |
CreateSchema | Gets a permission that can be included in the database permission set. | |
CreateService | Gets a permission that can be included in the database permission set. | |
CreateSymmetricKey | Gets a permission that can be included in the database permission set. | |
CreateSynonym | Gets a permission that can be included in the database permission set. | |
CreateTable | Gets a permission that can be included in the database permission set. | |
CreateType | Gets a permission that can be included in the database permission set. | |
CreateView | Gets a permission that can be included in the database permission set. | |
CreateXmlSchemaCollection | Gets a permission that can be included in the database permission set. | |
Delete | Gets a permission that can be included in the database permission set. | |
Execute | Gets a permission that can be included in the database permission set. | |
Insert | Gets a permission that can be included in the database permission set. | |
References | Gets a permission that can be included in the database permission set. | |
Select | Gets a permission that can be included in the database permission set. | |
Showplan | Gets a permission that can be included in the database permission set. | |
SubscribeQueryNotifications | Gets a permission that can be included in the database permission set. | |
TakeOwnership | Gets a permission that can be included in the database permission set. | |
Update | Gets a permission that can be included in the database permission set. | |
ViewDatabaseState | Gets a permission that can be included in the database permission set. | |
ViewDefinition | Gets a permission that can be included in the database permission set. |
Zum Anfang
Methoden
Name | Beschreibung | |
---|---|---|
Add | Returns a set of database permissions after adding a new database permission to an existing set of database permissions. | |
BitwiseOr | Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects. | |
Equals | Determines whether the referenced database permission object is equal to a specified object. (Überschreibt Object. . :: . .Equals(Object).) | |
Finalize | (Geerbt von Object.) | |
GetHashCode | This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (Überschreibt Object. . :: . .GetHashCode() () () ().) | |
GetType | (Geerbt von Object.) | |
MemberwiseClone | (Geerbt von Object.) | |
ToDatabasePermissionSet | Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object. | |
ToString | (Geerbt von Object.) |
Zum Anfang
Operatoren
Name | Beschreibung | |
---|---|---|
Addition | Creates a database permission set by performing an addition operation on two DatabasePermission objects. | |
BitwiseOr | Creates a database permission set by performing a bitwise OR operation on two DatabasePermission objects. | |
Equality | Compares two DatabasePermission objects in an equality operation. | |
Implicit Widening Implicit Implicit Implicit(DatabasePermission to DatabasePermissionSet) | Converts a single database permission object to a database permission set. | |
Inequality | Determines whether two DatabasePermission objects are not equal by performing an inequality operation. |
Zum Anfang
Hinweise
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
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch