PrivilegeTypes 열거형
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.
이 열거형에는 해당 멤버 값에 대한 비트 조합이 가능한 FlagsAttribute 특성이 있습니다.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo.dll의 Microsoft.SqlServer.Smo
구문
‘선언
<FlagsAttribute> _
Public Enumeration PrivilegeTypes
‘사용 방법
Dim instance As PrivilegeTypes
[FlagsAttribute]
public enum PrivilegeTypes
[FlagsAttribute]
public enum class PrivilegeTypes
[<FlagsAttribute>]
type PrivilegeTypes
public enum PrivilegeTypes
멤버
| 멤버 이름 | 설명 | |
|---|---|---|
| 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. |
주의
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.