v.24.10Improvement
Add WITH IMPLICIT and FINAL to SHOW GRANTS Command and Fix Bug with Implicit Grants
AddWITH IMPLICITandFINALkeywords to theSHOW GRANTScommand. Fix a minor bug with implicit grants: #70094. #70293 (pufit).
Why it matters
This feature addresses the need to differentiate between explicitly granted privileges and those inherited implicitly. It also fixes a minor bug related to implicit grants, improving the accuracy and clarity of privilege listings for users and administrators.How to use it
Users can utilize the enhancedSHOW GRANTS command with the new WITH IMPLICIT keyword to include implicitly inherited grants in the output, and the FINAL keyword to display the final set of effective grants. For example:SHOW GRANTS <code>WITH IMPLICIT</code> FOR user_name;
SHOW GRANTS <code>FINAL</code> FOR user_name;