system.privileges

Contient la liste de tous les privilèges disponibles pouvant être accordés à un utilisateur ou à un rôle.

​

Description

Contient la liste de tous les privilèges disponibles qui peuvent être accordés à un utilisateur ou à un rôle.

​

Colonnes

• privilege ([Enum16(‘SHOW DATABASES’ = 0, ‘SHOW TABLES’ = 1, ‘CHECK’ = 2, ‘SHOW COLUMNS’ = 3, ‘SHOW DICTIONARIES’ = 4, ‘SHOW’ = 5, ‘SHOW FILESYSTEM CACHES’ = 6, ‘SELECT’ = 7, ‘INSERT’ = 8, ‘ALTER UPDATE’ = 9, ‘ALTER DELETE’ = 10, ‘ALTER ADD COLUMN’ = 11, ‘ALTER MODIFY COLUMN’ = 12, ‘ALTER DROP COLUMN’ = 13, ‘ALTER COMMENT COLUMN’ = 14, ‘ALTER CLEAR COLUMN’ = 15, ‘ALTER RENAME COLUMN’ = 16, ‘ALTER MATERIALIZE COLUMN’ = 17, ‘ALTER COLUMN’ = 18, ‘ALTER MODIFY COMMENT’ = 19, ‘ALTER MODIFY DATABASE COMMENT’ = 20, ‘ALTER ORDER BY’ = 21, ‘ALTER SAMPLE BY’ = 22, ‘ALTER ADD INDEX’ = 23, ‘ALTER DROP INDEX’ = 24, ‘ALTER MATERIALIZE INDEX’ = 25, ‘ALTER CLEAR INDEX’ = 26, ‘ALTER INDEX’ = 27, ‘ALTER ADD STATISTICS’ = 28, ‘ALTER DROP STATISTICS’ = 29, ‘ALTER MODIFY STATISTICS’ = 30, ‘ALTER MATERIALIZE STATISTICS’ = 31, ‘ALTER STATISTICS’ = 32, ‘ALTER ADD PROJECTION’ = 33, ‘ALTER DROP PROJECTION’ = 34, ‘ALTER MATERIALIZE PROJECTION’ = 35, ‘ALTER CLEAR PROJECTION’ = 36, ‘ALTER PROJECTION’ = 37, ‘ALTER ADD CONSTRAINT’ = 38, ‘ALTER DROP CONSTRAINT’ = 39, ‘ALTER MODIFY CONSTRAINT’ = 40, ‘ALTER CONSTRAINT’ = 41, ‘ALTER TTL’ = 42, ‘ALTER MATERIALIZE TTL’ = 43, ‘ALTER REWRITE PARTS’ = 44, ‘ALTER SETTINGS’ = 45, ‘ALTER MOVE PARTITION’ = 46, ‘ALTER FETCH PARTITION’ = 47, ‘ALTER FREEZE PARTITION’ = 48, ‘ALTER UNLOCK SNAPSHOT’ = 49, ‘ALTER EXECUTE’ = 50, ‘ALTER DATABASE SETTINGS’ = 51, ‘ALTER NAMED COLLECTION’ = 52, ‘ALTER HANDLER’ = 53, ‘ALTER TABLE’ = 54, ‘ALTER DATABASE’ = 55, ‘ALTER VIEW MODIFY QUERY’ = 56, ‘ALTER VIEW MODIFY REFRESH’ = 57, ‘ALTER VIEW MODIFY SQL SECURITY’ = 58, ‘ALTER VIEW’ = 59, ‘ALTER’ = 60, ‘CREATE DATABASE’ = 61, ‘CREATE TABLE’ = 62, ‘CREATE VIEW’ = 63, ‘CREATE DICTIONARY’ = 64, ‘CREATE TEMPORARY TABLE’ = 65, ‘CREATE ARBITRARY TEMPORARY TABLE’ = 66, ‘CREATE TEMPORARY VIEW’ = 67, ‘CREATE FUNCTION’ = 68, ‘CREATE WORKLOAD’ = 69, ‘CREATE RESOURCE’ = 70, ‘CREATE NAMED COLLECTION’ = 71, ‘CREATE HANDLER’ = 72, ‘CREATE’ = 73, ‘DROP DATABASE’ = 74, ‘DROP TABLE’ = 75, ‘DROP VIEW’ = 76, ‘DROP DICTIONARY’ = 77, ‘DROP FUNCTION’ = 78, ‘DROP WORKLOAD’ = 79, ‘DROP RESOURCE’ = 80, ‘DROP NAMED COLLECTION’ = 81, ‘DROP HANDLER’ = 82, ‘DROP’ = 83, ‘UNDROP TABLE’ = 84, ‘TRUNCATE’ = 85, ‘OPTIMIZE’ = 86, ‘BACKUP’ = 87, ‘KILL QUERY’ = 88, ‘KILL TRANSACTION’ = 89, ‘MOVE PARTITION BETWEEN SHARDS’ = 90, ‘CREATE USER’ = 91, ‘ALTER USER’ = 92, ‘DROP USER’ = 93, ‘CREATE ROLE’ = 94, ‘ALTER ROLE’ = 95, ‘DROP ROLE’ = 96, ‘ROLE ADMIN’ = 97, ‘CREATE ROW POLICY’ = 98, ‘ALTER ROW POLICY’ = 99, ‘DROP ROW POLICY’ = 100, ‘CREATE MASKING POLICY’ = 101, ‘ALTER MASKING POLICY’ = 102, ‘DROP MASKING POLICY’ = 103, ‘CREATE QUOTA’ = 104, ‘ALTER QUOTA’ = 105, ‘DROP QUOTA’ = 106, ‘CREATE SETTINGS PROFILE’ = 107, ‘ALTER SETTINGS PROFILE’ = 108, ‘DROP SETTINGS PROFILE’ = 109, ‘ALLOW SQL SECURITY NONE’ = 110, ‘SHOW USERS’ = 111, ‘SHOW ROLES’ = 112, ‘SHOW ROW POLICIES’ = 113, ‘SHOW QUOTAS’ = 114, ‘SHOW SETTINGS PROFILES’ = 115, ‘SHOW MASKING POLICIES’ = 116, ‘SHOW ACCESS’ = 117, ‘IMPERSONATE’ = 118, ‘ACCESS MANAGEMENT’ = 119, ‘SHOW NAMED COLLECTIONS’ = 120, ‘SHOW NAMED COLLECTIONS SECRETS’ = 121, ‘NAMED COLLECTION’ = 122, ‘NAMED COLLECTION ADMIN’ = 123, ‘SHOW HANDLERS’ = 124, ‘SET DEFINER’ = 125, ‘TABLE ENGINE’ = 126, ‘SYSTEM SHUTDOWN’ = 127, ‘SYSTEM DROP DNS CACHE’ = 128, ‘SYSTEM DROP CONNECTIONS CACHE’ = 129, ‘SYSTEM PREWARM MARK CACHE’ = 130, ‘SYSTEM DROP MARK CACHE’ = 131, ‘SYSTEM DROP ICEBERG METADATA CACHE’ = 132, ‘SYSTEM DROP PAIMON METADATA CACHE’ = 133, ‘SYSTEM DROP AVRO SCHEMA CACHE’ = 134, ‘SYSTEM DROP PARQUET METADATA CACHE’ = 135, ‘SYSTEM DROP POINT IN POLYGON CACHE’ = 136, ‘SYSTEM PREWARM PRIMARY INDEX CACHE’ = 137, ‘SYSTEM DROP PRIMARY INDEX CACHE’ = 138, ‘SYSTEM DROP UNCOMPRESSED CACHE’ = 139, Nom d’un privilège pouvant être utilisé dans la commande GRANT.
• aliases (Array(String)) — Liste des alias pouvant être utilisés à la place du nom du privilège.
• level (Nullable(Enum8(‘GLOBAL’ = 0, ‘DATABASE’ = 1, ‘TABLE’ = 2, ‘DICTIONARY’ = 3, ‘VIEW’ = 4, ‘COLUMN’ = 5, ‘NAMED_COLLECTION’ = 6, ‘USER_NAME’ = 7, ‘TABLE_ENGINE’ = 8, ‘DEFINER’ = 9, ‘SOURCE’ = 10))) — Niveau du privilège. Les privilèges GLOBAL ne peuvent être accordés qu’au niveau global (ON *.*), les privilèges DATABASE peuvent être accordés sur une base de données spécifique (ON <database>.*) ou globalement (ON *.*), les privilèges TABLE peuvent être accordés sur une table spécifique, sur une base de données spécifique ou globalement, et les privilèges COLUMN peuvent être accordés comme les privilèges TABLE, tout en permettant également de spécifier des colonnes.
• parent_group (Nullable(Enum16(‘SHOW DATABASES’ = 0, ‘SHOW TABLES’ = 1, ‘CHECK’ = 2, ‘SHOW COLUMNS’ = 3, ‘SHOW DICTIONARIES’ = 4, ‘SHOW’ = 5, ‘SHOW FILESYSTEM CACHES’ = 6, ‘SELECT’ = 7, ‘INSERT’ = 8, ‘ALTER UPDATE’ = 9, ‘ALTER DELETE’ = 10, ‘ALTER ADD COLUMN’ = 11, ‘ALTER MODIFY COLUMN’ = 12, ‘ALTER DROP COLUMN’ = 13, ‘ALTER COMMENT COLUMN’ = 14, ‘ALTER CLEAR COLUMN’ = 15, ‘ALTER RENAME COLUMN’ = 16, ‘ALTER MATERIALIZE COLUMN’ = 17, ‘ALTER COLUMN’ = 18, ‘ALTER MODIFY COMMENT’ = 19, ‘ALTER MODIFY DATABASE COMMENT’ = 20, ‘ALTER ORDER BY’ = 21, ‘ALTER SAMPLE BY’ = 22, ‘ALTER ADD INDEX’ = 23, ‘ALTER DROP INDEX’ = 24, ‘ALTER MATERIALIZE INDEX’ = 25, ‘ALTER CLEAR INDEX’ = 26, ‘ALTER INDEX’ = 27, ‘ALTER ADD STATISTICS’ = 28, ‘ALTER DROP STATISTICS’ = 29, ‘ALTER MODIFY STATISTICS’ = 30, ‘ALTER MATERIALIZE STATISTICS’ = 31, ‘ALTER STATISTICS’ = 32, ‘ALTER ADD PROJECTION’ = 33, ‘ALTER DROP PROJECTION’ = 34, ‘ALTER MATERIALIZE PROJECTION’ = 35, ‘ALTER CLEAR PROJECTION’ = 36, ‘ALTER PROJECTION’ = 37, ‘ALTER ADD CONSTRAINT’ = 38, ‘ALTER DROP CONSTRAINT’ = 39, ‘ALTER MODIFY CONSTRAINT’ = 40, ‘ALTER CONSTRAINT’ = 41, ‘ALTER TTL’ = 42, ‘ALTER MATERIALIZE TTL’ = 43, ‘ALTER REWRITE PARTS’ = 44, ‘ALTER SETTINGS’ = 45, ‘ALTER MOVE PARTITION’ = 46, ‘ALTER FETCH PARTITION’ = 47, ‘ALTER FREEZE PARTITION’ = 48, ‘ALTER UNLOCK SNAPSHOT’ = 49, ‘ALTER EXECUTE’ = 50, ‘ALTER DATABASE SETTINGS’ = 51, ‘ALTER NAMED COLLECTION’ = 52, ‘ALTER HANDLER’ = 53, ‘ALTER TABLE’ = 54, ‘ALTER DATABASE’ = 55, ‘ALTER VIEW MODIFY QUERY’ = 56, ‘ALTER VIEW MODIFY REFRESH’ = 57, ‘ALTER VIEW MODIFY SQL SECURITY’ = 58, ‘ALTER VIEW’ = 59, ‘ALTER’ = 60, ‘CREATE DATABASE’ = 61, ‘CREATE TABLE’ = 62, ‘CREATE VIEW’ = 63, ‘CREATE DICTIONARY’ = 64, ‘CREATE TEMPORARY TABLE’ = 65, ‘CREATE ARBITRARY TEMPORARY TABLE’ = 66, ‘CREATE TEMPORARY VIEW’ = 67, ‘CREATE FUNCTION’ = 68, ‘CREATE WORKLOAD’ = 69, ‘CREATE RESOURCE’ = 70, ‘CREATE NAMED COLLECTION’ = 71, ‘CREATE HANDLER’ = 72, ‘CREATE’ = 73, ‘DROP DATABASE’ = 74, ‘DROP TABLE’ = 75, ‘DROP VIEW’ = 76, ‘DROP DICTIONARY’ = 77, ‘DROP FUNCTION’ = 78, ‘DROP WORKLOAD’ = 79, ‘DROP RESOURCE’ = 80, ‘DROP NAMED COLLECTION’ = 81, ‘DROP HANDLER’ = 82, ‘DROP’ = 83, ‘UNDROP TABLE’ = 84, ‘TRUNCATE’ = 85, ‘OPTIMIZE’ = 86, ‘BACKUP’ = 87, ‘KILL QUERY’ = 88, ‘KILL TRANSACTION’ = 89, ‘MOVE PARTITION BETWEEN SHARDS’ = 90, ‘CREATE USER’ = 91, ‘ALTER USER’ = 92, ‘DROP USER’ = 93, ‘CREATE ROLE’ = 94, ‘ALTER ROLE’ = 95, ‘DROP ROLE’ = 96, ‘ROLE ADMIN’ = 97, ‘CREATE ROW POLICY’ = 98, ‘ALTER ROW POLICY’ = 99, ‘DROP ROW POLICY’ = 100, ‘CREATE MASKING POLICY’ = 101, ‘ALTER MASKING POLICY’ = 102, ‘DROP MASKING POLICY’ = 103, ‘CREATE QUOTA’ = 104, ‘ALTER QUOTA’ = 105, ‘DROP QUOTA’ = 106, ‘CREATE SETTINGS PROFILE’ = 107, ‘ALTER SETTINGS PROFILE’ = 108, ‘DROP SETTINGS PROFILE’ = 109, ‘ALLOW SQL SECURITY NONE’ = 110, ‘SHOW USERS’ = 111, ‘SHOW ROLES’ = 112, ‘SHOW ROW POLICIES’ = 113, ‘SHOW QUOTAS’ = 114, ‘SHOW SETTINGS PROFILES’ = 115, ‘SHOW MASKING POLICIES’ = 116, ‘SHOW ACCESS’ = 117, ‘IMPERSONATE’ = 118, ‘ACCESS MANAGEMENT’ = 119, ‘SHOW NAMED COLLECTIONS’ = 120, ‘SHOW NAMED COLLECTIONS SECRETS’ = 121, ‘NAMED COLLECTION’ = 122, ‘NAMED COLLECTION ADMIN’ = 123, ‘SHOW HANDLERS’ = 124, ‘SET DEFINER’ = 125, ‘TABLE ENGINE’ = 126, ‘SYSTEM SHUTDOWN’ = 127, ‘SYSTEM DROP DNS CACHE’ = 128, ‘SYSTEM DROP CONNECTIONS CACHE’ = 129, ‘SYSTEM PREWARM MARK CACHE’ = 130, ‘SYSTEM DROP MARK CACHE’ = 131, ‘SYSTEM DROP ICEBERG METADATA CACHE’ = 132, ‘SYSTEM DROP PAIMON METADATA CACHE’ = 133, ‘SYSTEM DROP AVRO SCHEMA CACHE’ = 134, ‘SYSTEM DROP PARQUET METADATA CACHE’ = 135, ‘SYSTEM DROP POINT IN POLYGON CACHE’ = 136, ‘SYSTEM PREWARM PRIMARY INDEX CACHE’ = 137, ‘SYSTEM DROP PRIMARY INDEX CACHE’ = 138, ‘SYSTEM DROP UNCOMPRESSED CACHE’ = 139, ‘SYSTEM DROP VECTOR SIMILARITY INDEX CACHE’ = 140, ‘SYSTEM DROP TEXT INDEX TOKENS CACHE’ = 141, ‘SYSTEM DROP TEXT INDEX HEADER CACHE’ = 142, ‘SYSTEM DROP TEXT INDEX POSTINGS CACHE’ = 143, ‘SYSTEM DROP TEXT INDEX CACHES’ = 144, ‘SYSTEM DROP MMAP CACHE’ = 145, ‘SYSTEM DROP QUERY CONDITION CACHE’ = 146, ‘SYSTEM DROP ENCRYPTION HEADERS CACHE’ = 147, ‘SYSTEM DROP QUERY CACHE’ = 148, ‘SYSTEM DROP COMPILED EXPRESSION CACHE’ = 149, ‘SYSTEM DROP FILESYSTEM CACHE’ = 150, ‘SYSTEM DROP DISTRIBUTED CACHE’ = 151, ‘SYSTEM SYNC FILESYSTEM CACHE’ = 152, ‘SYSTEM DROP PAGE CACHE’ = 153, ‘SYSTEM DROP SCHEMA CACHE’ = 154, ‘SYSTEM DROP FORMAT SCHEMA CACHE’ = 155, ‘SYSTEM DROP S3 CLIENT CACHE’ = 156, ‘SYSTEM DROP CACHE’ = 157, ‘SYSTEM RELOAD CONFIG’ = 158, ‘SYSTEM RELOAD USERS’ = 159, ‘SYSTEM RELOAD DICTIONARY’ = 160, ‘SYSTEM RELOAD MODEL’ = 161, ‘SYSTEM RELOAD FUNCTION’ = 162, ‘SYSTEM RELOAD EMBEDDED DICTIONARIES’ = 163, ‘SYSTEM RELOAD ASYNCHRONOUS METRICS’ = 164, ‘SYSTEM RECONNECT ZOOKEEPER’ = 165, ‘SYSTEM RELOAD’ = 166, ‘SYSTEM RESTART DISK’ = 167, ‘SYSTEM WAIT BLOBS CLEANUP’ = 168, ‘SYSTEM MERGES’ = 169, ‘SYSTEM TTL MERGES’ = 170, ‘SYSTEM FETCHES’ = 171, ‘SYSTEM MOVES’ = 172, ‘SYSTEM PULLING REPLICATION LOG’ = 173, ‘SYSTEM CLEANUP’ = 174, ‘SYSTEM VIEWS’ = 175, ‘SYSTEM STREAMING ENGINES’ = 176, ‘SYSTEM BACKGROUND’ = 177, ‘SYSTEM DISTRIBUTED SENDS’ = 178, ‘SYSTEM REPLICATED SENDS’ = 179, ‘SYSTEM SENDS’ = 180, ‘SYSTEM REPLICATION QUEUES’ = 181, ‘SYSTEM VIRTUAL PARTS UPDATE’ = 182, ‘SYSTEM REDUCE BLOCKING PARTS’ = 183, ‘SYSTEM DROP REPLICA’ = 184, ‘SYSTEM SYNC REPLICA’ = 185, ‘SYSTEM REPLICA READINESS’ = 186, ‘SYSTEM RESTART REPLICA’ = 187, ‘SYSTEM RESTORE REPLICA’ = 188, ‘SYSTEM RESTORE DATABASE REPLICA’ = 189, ‘SYSTEM WAIT LOADING PARTS’ = 190, ‘SYSTEM WAIT QUERY RUNNER’ = 191, ‘SYSTEM SYNC DATABASE REPLICA’ = 192, ‘SYSTEM SYNC TRANSACTION LOG’ = 193, ‘SYSTEM SYNC FILE CACHE’ = 194, ‘SYSTEM FLUSH DISTRIBUTED’ = 195, ‘SYSTEM FLUSH LOGS’ = 196, ‘SYSTEM FLUSH ASYNC INSERT QUEUE’ = 197, ‘SYSTEM FLUSH OBJECT STORAGE QUEUE’ = 198, ‘SYSTEM FLUSH’ = 199, ‘SYSTEM THREAD FUZZER’ = 200, ‘SYSTEM UNFREEZE’ = 201, ‘SYSTEM UNLOCK SNAPSHOT’ = 202, ‘SYSTEM FAILPOINT’ = 203, ‘SYSTEM MEMORY’ = 204, ‘SYSTEM LISTEN’ = 205, ‘SYSTEM JEMALLOC’ = 206, ‘SYSTEM LOAD PRIMARY KEY’ = 207, ‘SYSTEM UNLOAD PRIMARY KEY’ = 208, ‘SYSTEM INSTRUMENT ADD’ = 209, ‘SYSTEM INSTRUMENT REMOVE’ = 210, ‘SYSTEM RESET DDL WORKER’ = 211, ‘SYSTEM’ = 212, ‘dictGet’ = 213, ‘displaySecretsInShowAndSelect’ = 214, ‘addressToLine’ = 215, ‘addressToLineWithInlines’ = 216, ‘addressToSymbol’ = 217, ‘demangle’ = 218, ‘INTROSPECTION’ = 219, ‘READ’ = 220, ‘WRITE’ = 221, ‘CLUSTER’ = 222, ‘FILE’ = 223, ‘URL’ = 224, ‘REMOTE’ = 225, ‘MONGO’ = 226, ‘REDIS’ = 227, ‘MYSQL’ = 228, ‘POSTGRES’ = 229, ‘SQLITE’ = 230, ‘ODBC’ = 231, ‘JDBC’ = 232, ‘HDFS’ = 233, ‘S3’ = 234, ‘HIVE’ = 235, ‘AZURE’ = 236, ‘KAFKA’ = 237, ‘NATS’ = 238, ‘RABBITMQ’ = 239, ‘YTSAURUS’ = 240, ‘ARROW FLIGHT’ = 241, ‘BIGQUERY’ = 242, ‘SOURCES’ = 243, ‘ALL’ = 244, ‘NONE’ = 245))) — Privilège parent - si le privilège parent est accordé, tous ses privilèges enfants sont également considérés comme accordés.