v.22.6Improvement

Allow User to Inspect Grants from Granted Roles

Allow a user to inspect grants from granted roles. #36941 (nvartolomei).
Introduces the ability for users to inspect grants that have been granted through roles in ClickHouse.

Why it matters

This feature solves the problem of lacking visibility into which permissions are inherited via granted roles. It provides users and administrators with better transparency and control over access rights in ClickHouse.

How to use it

Users can query system tables or use relevant SQL commands to inspect grants from roles that have been assigned to them or others. This inspection helps in understanding the effective permissions derived from roles.