v.25.8Improvement

Add a parameter column to system

Add a parameter column to system.grants to determine source type for GRANT READ/WRITE and the table engine for GRANT TABLE ENGINE. #85643 (MikhailBurdukov).
Added a parameter column to the system.grants table to indicate the source type for GRANT READ/WRITE privileges and the table engine for GRANT TABLE ENGINE privileges.

Why it matters

This feature enhances the system.grants table by providing more detailed information about granted privileges, specifically for GRANT READ/WRITE and GRANT TABLE ENGINE. It helps users identify the source type of these grants and understand the associated table engine, improving security auditing and privilege management.

How to use it

Users can query the system.grants table to see the new parameter column, which will display the source type or table engine relevant to the granted permission. There is no additional configuration required; the column is available by default after updating to the new version.