[Maria-developers] Account locked and USERS view?
![](https://secure.gravatar.com/avatar/1c91cbac39245fbf9babab5b6d9200d0.jpg?s=120&d=mm&r=g)
6 Jul
2022
6 Jul
'22
11:06 a.m.
Hi, Any reason why the ‘account locked’ attribute isn’t included in the USERS view? https://mariadb.com/kb/en/account-locking/ 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.
794
Age (days ago)
794
Last active (days ago)
0 comments
1 participants
participants (1)
-
Martijn Tonies (Upscene Productions)