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.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public enum PrivilegeTypes
/** @attribute FlagsAttribute() */ 
public enum PrivilegeTypes
public enum PrivilegeTypes

Member nameDescription
AllDatabasePrivilegesThe grantee has all privileges on the specified database. This privilege type applies to database objects.
AllObjectPrivilegesThe grantee has all the privileges that apply to the specified database object.
AlterThe grantee can alter the specified database.
BackupDatabaseThe grantee can back up the specified database.
BackupLogThe grantee can back up the transaction log for the specified database.
ControlThe grantee has full control over the specified database.
CreateDatabaseThe grantee can create the database.
CreateDefaultThe grantee can create a default database object on the specified database.
CreateFunctionThe grantee can create a user-defined function of the specified database.
CreateProcedureThe grantee can create stored procedure on the specified database.
CreateRuleThe grantee can create a rule on the specified database.
CreateTableThe grantee can create a table on the specified database.
CreateTypeThe grantee can create a user-defined type on the specified database.
CreateViewThe grantee can create a view on the specified database.
DeleteThe grantee can delete the specified database object.
DropThe grantee can drop the database.
DumpDatabaseThe grantee can dump the data in the specified database.
DumpTableThe grantee can dump the data in the specified table.
DumpTransactionThe grantee can dump the data in the specified transaction log.
ExecuteThe grantee can execute the specified database object.
InsertThe grantee can insert records into the specified database object.
ReferencesThe grantee can reference a column in another table in a primary key/foreign key relationship.
SelectThe grantee can select records from the specified database object.
UnknownThe grantee's privileges are unspecified.
UpdateThe grantee can update records on the specified database object.
ViewDefinitionInformation is still to come.

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions