Manually Unlocking a User Account in GBase 8a: Command and Privileges

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; Example: User u1 is permanently locked after 6 consecutive wrong passwords. The administrator logs in as gbase and runs: ALTER USER u1 ACCOUNT UNLOCK; u1 can then reconnect with the c...