maria-developers team mailing list archive

Thread
Date

Account locked and USERS view?

To: "MariaDB Developers" <maria-developers@xxxxxxxxxxxxxxxxxxx>
From: "Martijn Tonies \(Upscene Productions\)" <m.tonies@xxxxxxxxxxx>
Date: Wed, 6 Jul 2022 11:06:37 +0200
Arc-authentication-results: i=1; rspamd-674ffb986c-6tjmj; auth=pass smtp.auth=hostpapa smtp.mailfrom=m.tonies@xxxxxxxxxxx
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1657098431; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: dkim-signature; bh=giCnmngDZqmx6IQHUx/gKtGaS24pA/6Zc0LzV8q87ig=; b=U9UMqC8tKUghB4XVCwSKw6ZMVN3wwHjKw0+qbnk6T5VcHopbbRKtVW6nm7qjMDG0fkhd6k 1JYbDWsszijk+BXVXS4f2CLrcvy5eOOOCiVjVYAtSC2O9GKE/vUu6+DHqBAuPZtX8d4GG1 3WLaoFIXwmUBVDMlYsOJxhYjRbpY0LF272d7sB5LhRwAYcbEvgV3829mTrSdmfSyNAfvVd sMpiP78KSh7/QQBlLgdXQlIXV3ePaW6fz5LaJpaKnK+S6xw8R60Dnp1oVK9ggkhTKhxt2R fnIGbxVrqE+51Qo9M0UmjrOsCvHPzPvZzJFEgrnd6LDCZKjPh8gRKeckryPl+g==
Arc-seal: i=1; s=arc-2022; d=mailchannels.net; t=1657098431; a=rsa-sha256; cv=none; b=yaBdmPMgbhrHIgnQ4VLPKTKmMUspvfiwyloyHxHtluyhKPVphBq9SSO8PKhCfhC/ibfULc vFfd1gSE8PJlvYLi67R35eHhWg6qF+VZ69Z+p8bQ8WcMLYvvKRLjdPU1w8LCSCLwn80IcD ZDw4RgGOAIvQyEfPW1H17kk++puK20UCsowLm3dZ1CbdqsxtFVp6fllQtXFcnyBw2Or0Zf lfDIyv++6DdSKRGYA8yV531wgKypngFw0SoYC7fzhqcFX4EWqM1bGhrEvL4/kn3b5Wj2cf oI4XMMgfRTglu/xzfUqQ2L1ppXgUWYUynPxxVRp54KZui41upquY7Onvu4d3bQ==
Importance: Normal

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.