This topic describes how to manage accounts under a tenant.
Background information
On the Account Management page, you can view account information and perform related management operations, including locking an account, resetting a password, modifying the host, editing permissions, modifying remarks, and deleting an account.
Prerequisites
You have created an account. For related operations, see Create an account.
Procedure
Log in to the OceanBase Cloud console.
On the instance list page, click the expand icon next to the instance name, and then click the target tenant name.
Click Manage Access in the left-side navigation pane to go to the Accounts page.
Lock an account
Click the ··· icon in the Actions column of the target account and select Lock.
In the dialog box that appears, confirm the information and click Lock. After the account is locked, it cannot access the database.
Reset a password
Click the ··· icon in the Actions column of the target account and select Reset Password.
In the dialog box, enter and confirm the new password, then click OK.
Modify the host
Click the ··· icon in the Actions column of the target account and select Modify Host.
In the dialog box, enter the host address to be modified and click OK.
Edit permissions
Click the ··· icon in the Actions column of the target account and select Update Privilege.
Edit the permissions in the dialog box and click OK. For more information, see Account permission list.
Modify remarks
Click the ··· icon in the Actions column of the target account and select Edit Remarks.
In the dialog box that appears, modify the remarks and click OK.
Delete an account
Click the ··· icon in the Actions column of the target account and select Delete.
In the confirmation dialog box, enter delete and click Delete.
Note
Deleted accounts cannot be recovered. Proceed with caution.
Set a password policy
Note
The password policy setting feature requires an instance database version of V4.2.1 or later.
Log in to the OceanBase Cloud console.
On the instance list page, click the expand icon next to the instance name, then click the target tenant name.
Click Manage Access in the left-side navigation pane to go to the Accounts page.
Click Set password policy in the upper-right corner.
On the Set Password Policy page, configure the following parameters.
ParameterDescriptionMinimum password length The minimum length for an account password. The default is 8. The minimum length must be greater than or equal to the sum of the minimum number of uppercase and lowercase letters * 2, the number of digits, and the number of special characters. Minimum number of uppercase and lowercase letters (each) The minimum number of uppercase and lowercase letters required in the account password. The default is 2, meaning at least 2 uppercase letters and 2 lowercase letters. Minimum number of digits The minimum number of digits required in the account password. The default is 2. Minimum number of special characters The minimum number of special characters required in the account password. The default is 2. Account name check When enabled, passwords must not contain the account name; otherwise, the login will be directly rejected. Lock accounts after consecutive failed login attempts When enabled, you can set the Failed login attempt threshold and Lockout duration. When a user fails consecutive logins exceeding the threshold, the system will lock the account for the specified duration. Click OK to save the password policy. Subsequent passwords created or modified must meet the new policy; existing passwords are not affected.