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)
Syntax
'Declaration
<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. |
Remarks
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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.