How to check user settings in ClickHouse

Question

I have a user created by SQL command. I know there is the getSetting() function to check user settings. e.g. :

SELECT getSetting('async_insert');

But how to check other users' settings if you are a DBA? Is there any view/function/request for this purpose?

Answer 1

There is actually the SHOW ACCESS command showing user settings.