You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATEUSERuser1;
CREATE DICTIONARY dict
(
`x` Int32,
`y` Int32
)
PRIMARY KEY x
SOURCE(CLICKHOUSE())
LIFETIME(MIN 0 MAX 0)
LAYOUT(FLAT());
GRANT SHOW DICTIONARIES ON dict TO user1;
GRANTSELECTONsystem.dictionaries TO user1;
SHOW GRANTS FOR user1;
1. GRANT SHOW DICTIONARIES ON default.dict TO user1
2. GRANT SELECT ON system.dictionaries TO user1
SELECT name
FROMsystem.dictionaries
┌─name─┐
1. │ dict │
└──────┘
1 row in set. Elapsed: 0.001 sec.
SHOW DICTIONARIES
┌─name─┐
1. │ dict │
└──────┘
1 row in set. Elapsed: 0.001 sec.
user1:
SHOW DICTIONARIES
0 rows in set. Elapsed: 0.001 sec.
SHOW CREATE DICTIONARY dict
CREATE DICTIONARY default.dict
(
`x` Int32,
`y` Int32
)
PRIMARY KEY x
SOURCE(CLICKHOUSE())
LIFETIME(MIN 0 MAX 0)
LAYOUT(FLAT())
EXISTS dict
Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: user1: Not enough privileges. To execute this query, it's necessary to have the grant SHOW TABLES ON default.dict. (ACCESS_DENIED)
SELECT name
FROMsystem.dictionaries
0 rows in set. Elapsed: 0.001 sec.
According to docs, SHOW DICTIONARIES is enough for using EXISTS dictionary.
Why I do not see dictionary when I use SHOW DICTIONARIES?
Why I do not see anything in system.dictionaries?
The text was updated successfully, but these errors were encountered:
ClickHouse server version 24.4.1
defaults user:
user1:
According to docs,
SHOW DICTIONARIES
is enough for using EXISTS dictionary.Why I do not see dictionary when I use SHOW DICTIONARIES?
Why I do not see anything in system.dictionaries?
The text was updated successfully, but these errors were encountered: