Hi,
Any reason why the ‘account locked’ attribute isn’t included in the USERS
view?
It could be added like this:
if(json_value(mysql.global_priv.Priv, '$.account_locked') = 1, 'Y', 'N') AS
is_locked
With
regards,
Martijn Tonies
Upscene
Productions
https://www.upscene.com
Database Workbench - developer
tool for Oracle, SQL Server, PostgreSQL, MySQL, InterBase, NexusDB and
Firebird.