system.privileges 시스템 테이블

system.privileges 시스템 테이블

system.privileges 는 사용자나 역할에 부여할 수 있는 모든 권한(privilege) 목록을 담고 있어요.

출처: 문서

본문

Description

사용자 또는 역할에 부여할 수 있는 모든 사용 가능한 권한 목록을 포함해요.

Columns

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 MODIFY PROJECTION’ = 35, ‘ALTER MATERIALIZE PROJECTION’ = 36, ‘ALTER CLEAR PROJECTION’ = 37, ‘ALTER PROJECTION’ = 38, ‘ALTER ADD CONSTRAINT’ = 39, ‘ALTER DROP CONSTRAINT’ = 40, ‘ALTER MODIFY CONSTRAINT’ = 41, ‘ALTER CONSTRAINT’ = 42, ‘ALTER TTL’ = 43, ‘ALTER MATERIALIZE TTL’ = 44, ‘ALTER REWRITE PARTS’ = 45, ‘ALTER SETTINGS’ = 46, ‘ALTER MOVE PARTITION’ = 47, ‘ALTER FETCH PARTITION’ = 48, ‘ALTER FREEZE PARTITION’ = 49, ‘ALTER UNLOCK SNAPSHOT’ = 50, ‘ALTER EXECUTE’ = 51, ‘ALTER DATABASE SETTINGS’ = 52, ‘ALTER NAMED COLLECTION’ = 53, ‘ALTER HANDLER’ = 54, ‘ALTER TABLE’ = 55, ‘ALTER DATABASE’ = 56, ‘ALTER VIEW MODIFY QUERY’ = 57, ‘ALTER VIEW MODIFY REFRESH’ = 58, ‘ALTER VIEW MODIFY SQL SECURITY’ = 59, ‘ALTER VIEW’ = 60, ‘ALTER’ = 61, ‘CREATE DATABASE’ = 62, ‘CREATE TABLE’ = 63, ‘CREATE VIEW’ = 64, ‘CREATE DICTIONARY’ = 65, ‘CREATE TEMPORARY TABLE’ = 66, ‘CREATE ARBITRARY TEMPORARY TABLE’ = 67, ‘CREATE TEMPORARY VIEW’ = 68, ‘CREATE FUNCTION’ = 69, ‘CREATE WORKLOAD’ = 70, ‘CREATE RESOURCE’ = 71, ‘CREATE NAMED COLLECTION’ = 72, ‘CREATE HANDLER’ = 73, ‘CREATE’ = 74, ‘DROP DATABASE…) — 권한의 이름이에요.
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 MODIFY PROJECTION’ = 35, ‘ALTER MATERIALIZE PROJECTION’ = 36, ‘ALTER CLEAR PROJECTION’ = 37, ‘ALTER PROJECTION’ = 38, ‘ALTER ADD CONSTRAINT’ = 39, ‘ALTER DROP CONSTRAINT’ = 40, ‘ALTER MODIFY CONSTRAINT’ = 41, ‘ALTER CONSTRAINT’ = 42, ‘ALTER TTL’ = 43, ‘ALTER MATERIALIZE TTL’ = 44, ‘ALTER REWRITE PARTS’ = 45, ‘ALTER SETTINGS’ = 46, ‘ALTER MOVE PARTITION’ = 47, ‘ALTER FETCH PARTITION’ = 48, ‘ALTER FREEZE PARTITION’ = 49, ‘ALTER UNLOCK SNAPSHOT’ = 50, ‘ALTER EXECUTE’ = 51, ‘ALTER DATABASE SETTINGS’ = 52, ‘ALTER NAMED COLLECTION’ = 53, ‘ALTER HANDLER’ = 54, ‘ALTER TABLE’ = 55, ‘ALTER DATABASE’ = 56, ‘ALTER VIEW MODIFY QUERY’ = 57, ‘ALTER VIEW MODIFY REFRESH’ = 58, ‘ALTER VIEW MODIFY SQL SECURITY’ = 59, ‘ALTER VIEW’ = 60, ‘ALTER’ = 61, ‘CREATE DATABASE’ = 62, ‘CREATE TABLE’ = 63, ‘CREATE VIEW’ = 64, ‘CREATE DICTIONARY’ = 65, ‘CREATE TEMPORARY TABLE’ = 66, ‘CREATE ARBITRARY TEMPORARY TABLE’ = 67, ‘CREATE TEMPORARY VIEW’ = 68, ‘CREATE FUNCTION’ = 69, ‘CREATE WORKLOAD’ = 70, ‘CREATE RESOURCE’ = 71, ‘CREATE NAMED COLLECTION’ = 72, ‘CREATE HANDLER’ = 73, ‘CREATE’ = 74, ‘DROP DATABASE…) — 이 권한이 속한 상위 그룹이에요.