0

I'd like to enable SQL-driven Access Control and Account Management as mentioned in ClickHouse docs https://clickhouse.tech/docs/en/operations/access-rights/

However, it does not state whether sql-managed users are then replicated across cluster or have to be set per replica.

I would move to sql-driven access control only if it was true. Now I have to manage xml files per replica. I see no big advantage in moving to SQL if it's either not replicated.

simPod
  • 11,498
  • 17
  • 86
  • 139

1 Answers1

1

SQL-managed users are NOT replicated.

I see no big advantage in moving to SQL if it's either not replicated.

SQL managed users allows you to GRANT SELECT by table.

Denny Crane
  • 11,574
  • 2
  • 19
  • 30
  • So apart from the more granular permissions management there's no advantage over xml, right? If I consider xml easier to manage it makes sense to go with. – simPod Jan 12 '21 at 18:35