v.25.8Improvement
Add a parameter column to system
Add aparametercolumn tosystem.grantsto determine source type forGRANT READ/WRITEand the table engine forGRANT TABLE ENGINE. #85643 (MikhailBurdukov).
Why it matters
This feature enhances thesystem.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 thesystem.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.