PrivilegeTypes Enumeration

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.

Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
<FlagsAttribute> _
Public Enumeration PrivilegeTypes
[FlagsAttribute] 
public enum PrivilegeTypes
[FlagsAttribute] 
public enum class PrivilegeTypes
/** @attribute FlagsAttribute() */ 
public enum PrivilegeTypes
FlagsAttribute 
public enum PrivilegeTypes

Members

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

Notes

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

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

Microsoft.SqlServer.Management.Smo Namespace