v.22.7New Feature

Add explicit grants option for SELECT from system database

Add an option to require explicit grants to SELECT from the system database. Details: #38970 (Vitaly Baranov).
Added an option to require explicit grants for SELECT queries on the system database.

Why it matters

This feature enhances security by ensuring that users need explicit permissions to query the system database, which contains sensitive metadata. It prevents unauthorized access and helps enforce fine-grained access control.

How to use it

Enable this feature by configuring the appropriate access control settings that require explicit SELECT grants on the system database. Once enabled, users will need to have explicit privileges granted to query system tables.