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） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

权限（数据库引擎）