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 (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
<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 | The grantee can view the definition of the specified database. | |
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.