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.

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

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

[FlagsAttribute]
public enum PrivilegeTypes

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

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

Community Additions

ADD
Show: