DB level permission

[sadik...@gmail.com]

hi All,

is it possible to grant permission on below scenarios?

User AA  ---- read/write to Database UU

User BB -- read to Database UU , write to Database TT

Regards,

sadika

[Vitaliy Lyudvichenko]

Hi!

At the moment ClickHouse has a very limited support of user privileges.

The only things you can do are:

• set readonly flag for a user
  
• specify list of allowed databases for a user (section <allow_databases></allow_databases> in user's config)
  

четверг, 14 сентября 2017 г., 8:55:19 UTC+3 пользователь sadik...@gmail.com написал:

[meo bogliolo]

Now it is easy (since 20.4)

Enable the SQL access control and you can use standard RBAC grant statements like:

grant select on UU.* to BB;

grant select, insert on TT.* to BB;

...