PermissionType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Sql permissions
public enum PermissionTypetype PermissionType = Public Enum PermissionType- Inheritance
-
PermissionType
Fields
| Name | Value | Description |
|---|---|---|
| Unknown | 0 | Unknown |
| Insert | 1 | Insert |
| Select | 2 | Select |
| Update | 3 | Update |
| Delete | 4 | Delete |
| References | 5 | References |
| CreateDatabase | 6 | CreateDatabase |
| CreateDefault | 7 | CreateDefault |
| CreateFunction | 8 | CreateFunction |
| CreateProcedure | 9 | CreateProcedure |
| CreateRule | 10 | CreateRule |
| CreateTable | 11 | CreateTable |
| CreateView | 12 | CreateView |
| BackupDatabase | 13 | BackupDatabase |
| BackupLog | 14 | BackupLog |
| AdministerBulkOperations | 1000 | AdministerBulkOperations |
| Alter | 1001 | Alter |
| AlterAnyApplicationRole | 1002 | AlterAnyApplicationRole |
| AlterAnyAssembly | 1003 | AlterAnyAssembly |
| AlterAnyAsymmetricKey | 1004 | AlterAnyAsymmetricKey |
| AlterAnyCertificate | 1005 | AlterAnyCertificate |
| AlterAnyConnection | 1006 | AlterAnyConnection |
| AlterAnyContract | 1007 | AlterAnyContract |
| AlterAnyCredential | 1008 | AlterAnyCredential |
| AlterAnyDatabase | 1009 | AlterAnyDatabase |
| AlterAnyDatabaseDdlTrigger | 1010 | AlterAnyDatabaseDdlTrigger |
| AlterAnyDatabaseEventNotification | 1011 | AlterAnyDatabaseEventNotification |
| AlterAnyDataspace | 1012 | AlterAnyDataspace |
| AlterAnyEndpoint | 1013 | AlterAnyEndpoint |
| AlterAnyEventNotification | 1014 | AlterAnyEventNotification |
| AlterAnyFulltextCatalog | 1015 | AlterAnyFulltextCatalog |
| AlterAnyLinkedServer | 1016 | AlterAnyLinkedServer |
| AlterAnyLogin | 1017 | AlterAnyLogin |
| AlterAnyMessageType | 1018 | AlterAnyMessageType |
| AlterAnyRemoteServiceBinding | 1019 | AlterAnyRemoteServiceBinding |
| AlterAnyRole | 1020 | AlterAnyRole |
| AlterAnyRoute | 1021 | AlterAnyRoute |
| AlterAnySchema | 1022 | AlterAnySchema |
| AlterAnyService | 1023 | AlterAnyService |
| AlterAnySymmetricKey | 1024 | AlterAnySymmetricKey |
| AlterAnyUser | 1025 | AlterAnyUser |
| AlterResources | 1026 | AlterResources |
| AlterServerState | 1027 | AlterServerState |
| AlterSettings | 1028 | AlterSettings |
| AlterTrace | 1029 | AlterTrace |
| Authenticate | 1030 | Authenticate |
| AuthenticateServer | 1031 | AuthenticateServer |
| Checkpoint | 1034 | Checkpoint |
| Connect | 1035 | Connect |
| ConnectReplication | 1036 | ConnectReplication |
| ConnectSql | 1037 | ConnectSql |
| Control | 1038 | Control |
| ControlServer | 1039 | ControlServer |
| CreateAggregate | 1040 | CreateAggregate |
| CreateAnyDatabase | 1041 | CreateAnyDatabase |
| CreateAssembly | 1042 | CreateAssembly |
| CreateAsymmetricKey | 1043 | CreateAsymmetricKey |
| CreateCertificate | 1044 | CreateCertificate |
| CreateContract | 1045 | CreateContract |
| CreateDatabaseDdlEventNotification | 1047 | CreateDatabaseDdlEventNotification |
| CreateDdlEventNotification | 1048 | CreateDdlEventNotification |
| CreateEndpoint | 1050 | CreateEndpoint |
| CreateFulltextCatalog | 1051 | CreateFulltextCatalog |
| CreateMessageType | 1053 | CreateMessageType |
| CreateQueue | 1055 | CreateQueue |
| CreateRemoteServiceBinding | 1056 | CreateRemoteServiceBinding |
| CreateRole | 1057 | CreateRole |
| CreateRoute | 1058 | CreateRoute |
| CreateSchema | 1060 | CreateSchema |
| CreateService | 1061 | CreateService |
| CreateSymmetricKey | 1062 | CreateSymmetricKey |
| CreateSynonym | 1063 | CreateSynonym |
| CreateTraceEventNotification | 1065 | CreateTraceEventNotification |
| CreateType | 1066 | CreateType |
| CreateXmlSchemaCollection | 1068 | CreateXmlSchemaCollection |
| Execute | 1070 | Execute |
| ExternalAccessAssembly | 1071 | ExternalAccessAssembly |
| Impersonate | 1072 | Impersonate |
| Receive | 1074 | Receive |
| Send | 1077 | Send |
| Showplan | 1078 | Showplan |
| Shutdown | 1079 | Shutdown |
| SubscribeQueryNotifications | 1080 | SubscribeQueryNotifications |
| TakeOwnership | 1081 | TakeOwnership |
| UnsafeAssembly | 1082 | UnsafeAssembly |
| ViewAnyDatabase | 1084 | ViewAnyDatabase |
| ViewAnyDefinition | 1085 | ViewAnyDefinition |
| ViewChangeTracking | 1086 | ViewChangeTracking |
| ViewDatabaseState | 1087 | ViewDatabaseState |
| ViewDefinition | 1088 | ViewDefinition |
| ViewServerState | 1089 | ViewServerState |
| All | 1090 | All |
| 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 | ImpersonateAnyLogin |
| SelectAllUserSecurables | 1101 | SelectAllUserSecurables |
| AlterAnySecurityPolicy | 1102 | AlterAnySecurityPolicy |
| AlterAnyColumnEncryptionKey | 1103 | AlterAnyColumnEncryptionKey |
| AlterAnyColumnMasterKey | 1104 | AlterAnyColumnMasterKey |
| Unmask | 1105 | Unmask |
| AlterAnyMask | 1106 | AlterAnyMask |
| ViewAnyColumnMasterKeyDefinition | 1107 | ViewAnyColumnMasterKeyDefinition |
| ViewAnyColumnEncryptionKeyDefinition | 1108 | ViewAnyColumnEncryptionKeyDefinition |
| AlterAnyExternalDataSource | 1109 | AlterAnyExternalDataSource |
| AlterAnyExternalFileFormat | 1110 | AlterAnyExternalFileFormat |
| AlterAnyDatabaseScopedConfiguration | 1111 | AlterAnyDatabaseScopedConfiguration |
| AlterAnySensitivityClassification | 1112 | AlterAnySensitivityClassification |
| ViewAnySensitivityClassification | 1113 | ViewAnySensitivityClassification |
| KillDatabaseConnection | 1114 | KillDatabaseConnection |
| ExecuteAnyExternalScript | 1115 | ExecuteAnyExternalScript |
| AdministerDatabaseBulkOperations | 1116 | AdministerDatabaseBulkOperations |
| OwnershipChaining | 1117 | OwnershipChaining |
| AlterAnyExternalLanguage | 1118 | AlterAnyExternalLanguage |
| AlterAnyExternalLibrary | 1119 | AlterAnyExternalLibrary |
| AlterAnyExternalStream | 1120 | AlterAnyExternalStream |
| AlterAnyExternalJob | 1121 | AlterAnyExternalJob |
| CreateUser | 1122 | CreateUser |
| ViewDatabaseSecurityState | 1123 | ViewDatabaseSecurityState |
| ViewDatabasePerformanceState | 1124 | ViewDatabasePerformanceState |
| ViewSecurityDefinition | 1125 | ViewSecurityDefinition |
| ViewCryptographicallySecuredDefinition | 1126 | ViewCryptographicallySecuredDefinition |
| EnableLedger | 1127 | EnableLedger |
| AlterLedger | 1128 | AlterLedger |
| ViewLedgerContent | 1129 | ViewLedgerContent |
| ExecuteAnyExternalEndpoint | 1130 | ExecuteAnyExternalEndpoint |
| CreateLogin | 1131 | CreateLogin |
| ViewAnySecurityDefinition | 1132 | ViewAnySecurityDefinition |
| ViewServerSecurityState | 1133 | ViewServerSecurityState |
| ViewServerPerformanceState | 1134 | ViewServerPerformanceState |
| AlterAnyEventSession | 1135 | AlterAnyEventSession |
| ViewAnyCryptographicallySecuredDefinition | 1136 | ViewAnyCryptographicallySecuredDefinition |
| CreateExternalLanguage | 1137 | CreateExternalLanguage |
| CreateExternalLibrary | 1138 | CreateExternalLibrary |
| 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 | ViewAnyErrorLog |
| ViewDatabaseSecurityAudit | 1158 | ViewDatabaseSecurityAudit |
| ViewServerSecurityAudit | 1159 | ViewServerSecurityAudit |
| AlterLedgerConfiguration | 1160 | AlterLedgerConfiguration |
| ViewAnyPerformanceDefinition | 1161 | ViewAnyPerformanceDefinition |
| ViewPerformanceDefinition | 1162 | ViewPerformanceDefinition |