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.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo..::..DatabasePermission
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class DatabasePermission
用法
Dim instance As DatabasePermission
public sealed class DatabasePermission
public ref class DatabasePermission sealed
[<SealedAttribute>]
type DatabasePermission = class end
public final class DatabasePermission
DatabasePermission 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
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. |
页首
方法
名称 | 说明 | |
---|---|---|
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. (覆盖 Object. . :: . .Equals(Object)。) | |
Finalize | (从 Object 继承。) | |
GetHashCode | This method supports the SQL Server infrastructure and is not intended to be used directly from your code. (覆盖 Object. . :: . .GetHashCode() () () ()。) | |
GetType | (从 Object 继承。) | |
MemberwiseClone | (从 Object 继承。) | |
ToDatabasePermissionSet | Returns a set of database permissions, based on a single database permission, by converting a DatabasePermission object to a DatabasePermissionSet object. | |
ToString | (从 Object 继承。) |
页首
运算符
名称 | 说明 | |
---|---|---|
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. |
页首
注释
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
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。不保证所有实例成员都是线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。