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)
Syntax
'Declaration
<FlagsAttribute> _
Public Enumeration PrivilegeTypes
'Usage
Dim instance As PrivilegeTypes
[FlagsAttribute]
public enum PrivilegeTypes
[FlagsAttribute]
public enum class PrivilegeTypes
[<FlagsAttribute>]
type PrivilegeTypes
public enum PrivilegeTypes
Members
| Member name | Description | |
|---|---|---|
| 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. |
Remarks
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.