This topic describes how to manage accounts in a tenant.
Background information
On the account management page, you can view account information and perform management operations, including locking an account, resetting a password, modifying a host, editing permissions, modifying remarks, and deleting an account.
Prerequisites
You have created an account. For more information, see Create an account.
Procedure
Log in to the OceanBase Cloud console.
In the instance list, click the expand icon to the left of the instance name and then click the name of the target tenant.
In the left-side navigation pane, click Manage Access to go to the account management page.
Lock an account
In the Actions column of the target account, click the ··· icon and select Lock.
In the dialog box that appears, click Lock. After the account is locked, it cannot access the database.
Reset a password
In the Actions column of the target account, click the ··· icon and select Reset Password.
In the dialog box that appears, enter and confirm the new password, and then click OK.
Modify a host
In the Actions column of the target account, click the ··· icon and select Modify Host.
In the dialog box that appears, enter the new host address and click OK.
Edit permissions
In the Actions column of the target account, click the ··· icon and select Update Privilege.
In the dialog box that appears, edit the permissions and click OK. For more information, see Account permissions.
Modify remarks
In the Actions column of the target account, click the ··· icon and select Edit Remarks.
In the dialog box that appears, modify the remarks and click OK.
Delete an account
In the Actions column of the target account, click the ··· icon and select Delete.
In the dialog box that appears, enter delete and click Delete.
Notice
After an account is deleted, it cannot be restored. Proceed with caution.
Set a password policy
Note
The password policy feature is available only in instances of OceanBase Database V4.2.1 and later.
Log in to the OceanBase Cloud console.
In the instance list, click the expand icon next to the name of the instance, and then click the name of the target tenant.
In the left-side navigation pane, click Manage Access to go to the account management page.
In the upper-right corner of the page, click Set Password Policy.
On the page that appears, set the following parameters.
Parameter Description Minimum Length The minimum length of the account password. The default value is 8. The minimum password length must be greater than or equal to the sum of the minimum number of uppercase and lowercase letters * 2, digits, and special characters. Minimum Uppercase and Lowercase Letters The minimum number of uppercase and lowercase letters in the account password. The default value is 2, which means that the password must contain at least 2 uppercase letters and 2 lowercase letters. Minimum Digits The minimum number of digits in the account password. The default value is 2. Minimum Special Characters The minimum number of special characters in the account password. The default value is 2. Account Name Detection If this option is enabled, the password cannot contain the account name. If it does, the system will reject the password. Lockout upon Consecutive Login Failures If this option is enabled, you can set Threshold and Lockout Duration. When the number of consecutive login failures exceeds the threshold, the system will lock the account for the specified duration. Click OK. The new password policy takes effect for passwords created or modified after this operation. Existing passwords are not affected.
