Artigo
09/28/2010

Enumeração PrivilegeTypes

The PrivilegeTypes enumeration contains values that are used to specify the operations that the grantee can perform on the specified object when permission is granted.

Esta enumeração tem um atributo FlagsAttribute que permite uma combinação bit a bit de seus valores de membros.

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

Sintaxe

'Declaração
<FlagsAttribute> _
Public Enumeration PrivilegeTypes
'Uso
Dim instance As PrivilegeTypes

[FlagsAttribute]
public enum PrivilegeTypes

[FlagsAttribute]
public enum class PrivilegeTypes

[<FlagsAttribute>]
type PrivilegeTypes

public enum PrivilegeTypes

Membros

	Nome do membro	Descrição
	Unknown	The grantee's privileges are unspecified.
	Select	The grantee can select records from the specified database object.
	Insert	The grantee can insert records into the specified database object.
	Update	The grantee can update records on the specified database object.
	Delete	The grantee can delete the specified database object.
	Execute	The grantee can execute the specified database object.
	References	The grantee can reference a column in another table in a primary key/foreign key relationship.
	ViewDefinition
	Control	The grantee has full control over the specified database.
	Alter	The grantee can alter the specified database.
	Drop	The grantee can drop the database.
	AllObjectPrivileges	The grantee has all the privileges that apply to the specified database object.
	CreateTable	The grantee can create a table on the specified database.
	CreateDatabase	The grantee can create the database.
	CreateView	The grantee can create a view on the specified database.
	CreateProcedure	The grantee can create stored procedure on the specified database.
	DumpDatabase	The grantee can dump the data in the specified database.
	CreateDefault	The grantee can create a default database object on the specified database.
	DumpTransaction	The grantee can dump the data in the specified transaction log.
	CreateRule	The grantee can create a rule on the specified database.
	DumpTable	The grantee can dump the data in the specified table.
	CreateFunction	The grantee can create a user-defined function of the specified database.
	CreateType	The grantee can create a user-defined type on the specified database.
	AllDatabasePrivileges	The grantee has all privileges on the specified database. This privilege type applies to database objects.
	BackupDatabase	The grantee can back up the specified database.
	BackupLog	The grantee can back up the transaction log for the specified database.

Comentários

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Consulte também

Referência

Namespace Microsoft.SqlServer.Management.Smo

Compartilhar via