PermissionType 列舉
定義
重要
部分資訊涉及發行前產品，在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊，不做任何明確或隱含的瑕疵擔保。
SQL 權限
public enum PermissionTypetype PermissionType = Public Enum PermissionType- 繼承
-
PermissionType
欄位
| 名稱 | 值 | Description |
|---|---|---|
| Unknown | 0 | Unknown |
| Insert | 1 | 插入 |
| Select | 2 | 選擇 |
| Update | 3 | 更新 |
| Delete | 4 | Delete |
| References | 5 | 參考 |
| CreateDatabase | 6 | CreateDatabase |
| CreateDefault | 7 | CreateDefault |
| CreateFunction | 8 | CreateFunction |
| CreateProcedure | 9 | CreateProcedure |
| CreateRule | 10 | 創造規則 |
| CreateTable | 11 | CreateTable |
| CreateView | 12 | CreateView |
| BackupDatabase | 13 | 備份資料庫 |
| BackupLog | 14 | 備份日誌 |
| AdministerBulkOperations | 1000 | 管理大宗作業 |
| Alter | 1001 | Alter |
| AlterAnyApplicationRole | 1002 | AlterAnyApplicationRole |
| AlterAnyAssembly | 1003 | AlterAnyAssembly |
| AlterAnyAsymmetricKey | 1004 | AlterAnyAsymmetricKey |
| AlterAnyCertificate | 1005 | AlterAnyCertificate |
| AlterAnyConnection | 1006 | 另一種連結 |
| AlterAnyContract | 1007 | AlterAny合約 |
| AlterAnyCredential | 1008 | AlterAnyCredential |
| AlterAnyDatabase | 1009 | AlterAnyDatabase |
| AlterAnyDatabaseDdlTrigger | 1010 | AlterAnyDatabaseDdlTrigger |
| AlterAnyDatabaseEventNotification | 1011 | AlterAnyDatabaseEventNotification |
| AlterAnyDataspace | 1012 | AlterAnyDataspace |
| AlterAnyEndpoint | 1013 | AlterAnyEndpoint |
| AlterAnyEventNotification | 1014 | 變換任何事件通知 |
| AlterAnyFulltextCatalog | 1015 | AlterAny全文目錄 |
| AlterAnyLinkedServer | 1016 | AlterAnyLinkedServer |
| AlterAnyLogin | 1017 | AlterAnyLogin |
| AlterAnyMessageType | 1018 | AlterAnyMessageType |
| AlterAnyRemoteServiceBinding | 1019 | AlterAnyRemoteServiceBinding |
| AlterAnyRole | 1020 | 替代任一角色 |
| AlterAnyRoute | 1021 | 替代任意路線 |
| AlterAnySchema | 1022 | AlterAnySchema |
| AlterAnyService | 1023 | AlterAnyService |
| AlterAnySymmetricKey | 1024 | AlterAnySymmetricKey |
| AlterAnyUser | 1025 | 變換使用者 |
| AlterResources | 1026 | 替代資源 |
| AlterServerState | 1027 | AlterServerState |
| AlterSettings | 1028 | AlterSettings |
| AlterTrace | 1029 | AlterTrace |
| Authenticate | 1030 | Authenticate |
| AuthenticateServer | 1031 | AuthenticateServer |
| Checkpoint | 1034 | Checkpoint |
| Connect | 1035 | 連線 |
| ConnectReplication | 1036 | ConnectReplication |
| ConnectSql | 1037 | ConnectSQL |
| Control | 1038 | 管理 |
| ControlServer | 1039 | 控制伺服器 |
| CreateAggregate | 1040 | CreateAggregate |
| CreateAnyDatabase | 1041 | CreateAnyDatabase |
| CreateAssembly | 1042 | CreateAssembly |
| CreateAsymmetricKey | 1043 | CreateAsymmetricKey |
| CreateCertificate | 1044 | CreateCertificate |
| CreateContract | 1045 | 創建合約 |
| CreateDatabaseDdlEventNotification | 1047 | CreateDatabaseDdlEventNotification |
| CreateDdlEventNotification | 1048 | CreateDdlEventNotification |
| CreateEndpoint | 1050 | CreateEndpoint |
| CreateFulltextCatalog | 1051 | CreateFulltext目錄 |
| CreateMessageType | 1053 | CreateMessageType |
| CreateQueue | 1055 | 創建佇列 |
| CreateRemoteServiceBinding | 1056 | CreateRemoteServiceBinding |
| CreateRole | 1057 | CreateRole |
| CreateRoute | 1058 | CreateRoute |
| CreateSchema | 1060 | CreateSchema |
| CreateService | 1061 | CreateService |
| CreateSymmetricKey | 1062 | CreateSymmetricKey |
| CreateSynonym | 1063 | 創造同義詞 |
| CreateTraceEventNotification | 1065 | CreateTraceEventNotification |
| CreateType | 1066 | CreateType |
| CreateXmlSchemaCollection | 1068 | CreateXmlSchemaCollection |
| Execute | 1070 | 執行 |
| ExternalAccessAssembly | 1071 | 外部存取組件 |
| Impersonate | 1072 | 冒充 |
| Receive | 1074 | 收到 |
| Send | 1077 | 發送 |
| Showplan | 1078 | 顯示計畫 |
| Shutdown | 1079 | 關機 |
| SubscribeQueryNotifications | 1080 | 訂閱查詢通知 |
| TakeOwnership | 1081 | 擁有權 |
| UnsafeAssembly | 1082 | UnsafeAssembly |
| ViewAnyDatabase | 1084 | 查看任何資料庫 |
| ViewAnyDefinition | 1085 | 查看任何定義 |
| ViewChangeTracking | 1086 | 檢視變更追蹤 |
| ViewDatabaseState | 1087 | ViewDatabaseState |
| ViewDefinition | 1088 | ViewDefinition |
| ViewServerState | 1089 | ViewServerState |
| All | 1090 | 全部 |
| AlterAnyDatabaseAudit | 1091 | AlterAnyDatabaseAudit |
| AlterAnyServerAudit | 1092 | AlterAnyServerAudit |
| CreateSequence | 1093 | CreateSequence |
| AlterAnyServerRole | 1094 | AlterAnyServerRole |
| CreateServerRole | 1095 | CreateServerRole |
| CreateAvailabilityGroup | 1096 | CreateAvailabilityGroup |
| AlterAnyAvailabilityGroup | 1097 | AlterAnyAvailabilityGroup |
| AlterAnyDatabaseEventSession | 1098 | AlterAnyDatabaseEventSession |
| ConnectAnyDatabase | 1099 | ConnectAnyDatabase |
| ImpersonateAnyLogin | 1100 | 假冒任何登入 |
| SelectAllUserSecurables | 1101 | SelectAllUserSecurables |
| AlterAnySecurityPolicy | 1102 | AlterAnySecurityPolicy |
| AlterAnyColumnEncryptionKey | 1103 | AlterAnyColumnEncryptionKey |
| AlterAnyColumnMasterKey | 1104 | AlterAnyColumnMasterKey |
| Unmask | 1105 | 揭開面具 |
| AlterAnyMask | 1106 | 變形面具 |
| ViewAnyColumnMasterKeyDefinition | 1107 | ViewAnyColumnMasterKeyDefinition |
| ViewAnyColumnEncryptionKeyDefinition | 1108 | ViewAnyColumnEncryptionKeyDefinition |
| AlterAnyExternalDataSource | 1109 | AlterAnyExternalDataSource |
| AlterAnyExternalFileFormat | 1110 | AlterAnyExternalFileFormat |
| AlterAnyDatabaseScopedConfiguration | 1111 | AlterAnyDatabaseScopedConfiguration |
| AlterAnySensitivityClassification | 1112 | AlterAnySensitivity 分類 |
| ViewAnySensitivityClassification | 1113 | 檢視任何敏感度分類 |
| KillDatabaseConnection | 1114 | 殺戮資料庫連結 |
| ExecuteAnyExternalScript | 1115 | 執行任意外部腳本 |
| AdministerDatabaseBulkOperations | 1116 | 管理資料庫大容量作業 |
| OwnershipChaining | 1117 | 所有權鏈 |
| AlterAnyExternalLanguage | 1118 | AlterAnyExternalLanguage |
| AlterAnyExternalLibrary | 1119 | AlterAnyExternalLibrary |
| AlterAnyExternalStream | 1120 | AlterAnyExternalStream |
| AlterAnyExternalJob | 1121 | AlterAnyExternalJob |
| CreateUser | 1122 | 創建用戶 |
| ViewDatabaseSecurityState | 1123 | ViewDatabaseSecurityState |
| ViewDatabasePerformanceState | 1124 | ViewDatabasePerformanceState |
| ViewSecurityDefinition | 1125 | ViewSecurityDefinition |
| ViewCryptographicallySecuredDefinition | 1126 | 視密碼學安全定義 |
| EnableLedger | 1127 | 啟用帳本 |
| AlterLedger | 1128 | AlterLedger |
| ViewLedgerContent | 1129 | ViewLedgerContent |
| ExecuteAnyExternalEndpoint | 1130 | ExecuteAnyExternalEndpoint |
| CreateLogin | 1131 | CreateLogin |
| ViewAnySecurityDefinition | 1132 | ViewAnySecurityDefinition |
| ViewServerSecurityState | 1133 | ViewServerSecurityState |
| ViewServerPerformanceState | 1134 | ViewServerPerformanceState |
| AlterAnyEventSession | 1135 | 變換任何事件會話 |
| ViewAnyCryptographicallySecuredDefinition | 1136 | 查看任何加密學安全定義 |
| CreateExternalLanguage | 1137 | CreateExternalLanguage |
| CreateExternalLibrary | 1138 | 建立外部函式庫 |
| AlterAnyDatabaseEventSessionAddEvent | 1139 | AlterAnyDatabaseEventSessionAddEvent |
| AlterAnyDatabaseEventSessionAddTarget | 1140 | AlterAnyDatabaseEventSessionAddTarget |
| AlterAnyDatabaseEventSessionDisable | 1141 | AlterAnyDatabaseEventSessionDisable |
| AlterAnyDatabaseEventSessionDropEvent | 1142 | AlterAnyDatabaseEventSessionDropEvent |
| AlterAnyDatabaseEventSessionDropTarget | 1143 | AlterAnyDatabaseEventSessionDropTarget |
| AlterAnyDatabaseEventSessionEnable | 1144 | AlterAnyDatabaseEventSessionEnable |
| AlterAnyDatabaseEventSessionOption | 1145 | AlterAnyDatabaseEventSessionOption |
| AlterAnyEventSessionAddEvent | 1146 | AlterAnyEventSessionAddEvent |
| AlterAnyEventSessionAddTarget | 1147 | AlterAnyEventSessionAddTarget |
| AlterAnyEventSessionDisable | 1148 | AlterAnyEventSessionDisable |
| AlterAnyEventSessionDropEvent | 1149 | AlterAnyEventSessionDropEvent |
| AlterAnyEventSessionDropTarget | 1150 | AlterAnyEventSessionDropTarget |
| AlterAnyEventSessionEnable | 1151 | AlterAnyEventSessionEnable |
| AlterAnyEventSessionOption | 1152 | AlterAnyEventSessionOption |
| CreateAnyDatabaseEventSession | 1153 | CreateAnyDatabaseEventSession |
| CreateAnyEventSession | 1154 | CreateAnyEventSession |
| DropAnyDatabaseEventSession | 1155 | DropAnyDatabaseEventSession |
| DropAnyEventSession | 1156 | DropAnyEventSession |
| ViewAnyErrorLog | 1157 | 查看任何錯誤日誌 |
| ViewDatabaseSecurityAudit | 1158 | ViewDatabaseSecurityAudit |
| ViewServerSecurityAudit | 1159 | ViewServerSecurityAudit |
| AlterLedgerConfiguration | 1160 | AlterLedgerConfiguration |
| ViewAnyPerformanceDefinition | 1161 | ViewAnyPerformanceDefinition |
| ViewPerformanceDefinition | 1162 | ViewPerformanceDefinition |