When a user account is permanently locked in GBase 8a due to excessive failed login attempts, a DBA can unlock it with the ALTER USER ... ACCOUNT UNLOCK command. This operation requires the CREATE USER privilege. 1. The Unlock Command Syntax: ALTER USER < username > ACCOUNT UNLOCK ; Enter fullscreen mode Exit fullscreen mode Example: User u1 is permanently locked after 6 consecutive wrong passwords. The administrator logs in as gbase and runs: ALTER USER u1 ACCOUNT UNLOCK ; Enter fullscreen mode Exit fullscreen mode u1 can then reconnect with the correct password. 2. Required Privileges Running ALTER USER ... ACCOUNT UNLOCK requires the CREATE USER privilege (or ALL PRIVILEGES ). The root and gbase users have this privilege by default and can unlock any account. A regular DBA must be explicitly granted CREATE USER : GRANT CREATE USER ON * . * TO 'dba_user' @ '%' ; Enter fullscreen mode Exit fullscreen mode Even with this privilege, the DBA's own account remains subject to the lockout policy. 3.…