system.privileges - ClickHouse Documentation

Описание

Содержит список всех доступных привилегий, которые можно выдать пользователю или роли.

Столбцы

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, ‘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)) — Название привилегии, которую можно использовать в команде GRANT.
aliases (Array(String)) — Список псевдонимов, которые можно использовать вместо названия привилегии.
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))) — Уровень привилегии. Привилегии GLOBAL можно предоставлять только на глобальном уровне (ON *.*), привилегии DATABASE можно предоставлять для конкретной базы данных (ON <database>.*) или глобально (ON *.*), привилегии TABLE можно предоставлять для конкретной таблицы, для конкретной базы данных или глобально, а привилегии COLUMN можно предоставлять так же, как и привилегии TABLE, но при этом также можно указывать столбцы.
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))) — Родительская привилегия — если родительская привилегия предоставлена, то все её дочерние привилегии также считаются предоставленными.

Последнее изменение 14 августа 2026 г.