Changing privileges via configuration files in undocumented

[x-yuri]

The docs says:

You can configure access entities using:

• SQL-driven workflow.
• Server configuration files users.xml and config.xml.

We recommend using SQL-driven workflow. Both of the configuration methods work simultaneously, so if you use the server configuration files for managing accounts and access rights, you can smoothly switch to SQL-driven workflow.

If you mention that one can use configuration files to change privileges, it should documented how that could be done. At least you should say why using configuration files is not recommended.

[DanRoscigno]

I am working through the setting docs. Thanks for raising this @x-yuri

[DanRoscigno]

Notes:

Pages related to user settings / profiles:

These two pages appear to be the XML and SQL methods to do the same thing

• https://clickhouse.com/docs/en/operations/access-rights

• https://clickhouse.com/docs/en/operations/settings/settings-users

  • if they cover the same content, then create a tabbed page and make this the main page for the topic

• ~https://clickhouse.com/docs/en/sql-reference/statements/alter/setting~

  • ignore this page; this is actually ALTER TABLE setting

• https://clickhouse.com/docs/en/sql-reference/statements/create/settings-profile

  • Move to snippet
  • the syntax is not defined, needs full details (for example, CONST is probably a constraint on the setting, how is a constraint written?)
  • Add an example assigning the profile to another user (not at profile creation time)

• https://clickhouse.com/docs/en/sql-reference/statements/alter/settings-profile

  • Move to snippet

• https://clickhouse.com/docs/en/operations/settings

  • Are settings set via CREATE SETTINGS PROFILE the same priority as editing the user profile via XML?

• ~https://clickhouse.com/docs/en/operations/settings/settings~

  • these are only set in config.xml or config.yml

• https://clickhouse.com/docs/en/operations/settings/settings-profiles

  • probably add this to the XML file tab of the main page for the section as the SQL version of the main page already has a section on profiles

• https://clickhouse.com/docs/en/operations/settings/constraints-on-settings

• https://clickhouse.com/docs/en/operations/configuration-files

• https://clickhouse.com/docs/en/operations/settings/permissions-for-queries

To Do:

• [ ] reduce clicking around by including the short reference pages into a guide via import
• [ ] Clarify the difference between a setting that assigns privs to a user (e.g, setting readonly) and a setting related to the behavior of ClcikHouse when a particular user is performing a query (e.g., async inserts). Are there differences? Maybe they are managed the same way, and we just need to note that there are different types of settings that can be associated with a user or user profile.
• [ ] combine guide documentation
• [ ] add redirects