ClickHouse: Can a user change his own password?

user_16182825 0
Viewed 1658

In ClickHouse, is it possible to GRANT a user for changing his own password but without allowing him to alter his privileges nor the privileges/password of other users?

If I set GRANT ALTER USER TO myuser, I will allow myuser to change the password and the privileges of all the users. And that I don't want.

clickhouse
1 Answers

As I understood the final goal is to avoid compromising/sharing a 'fresh' client password.

I would suggest storing hashed passwords instead of plain text - see for details user settings - user_name/password.

In this case,

  • user should send to the admin the hashed password
  • and admin set it up by yourself by using ALTER USER.
user_3032980
Related