TencentDB for SQL Server supports creating, deleting accounts, or modifying account permissions through the Account Management page in the console. It is prohibited to execute the creation, deletion, or modification of account permissions through Microsoft SQL Server Management.
Note:
The created account name and password will be used when connecting to TencentDB for SQL Server. Please store them properly.
Operation step
1. log in to the SQL Server Console, click Instance ID or the Operation column's Manage to enter the instance management page.
2. On the instance management page, select Account Management > Create Account, fill in the relevant information in the popup dialog, and after confirming it is correct, click OK.
Parameter
Description
Account Name
Account Name: It can contain 1–50 letters, digits, or underscores and must start with a letter.
Optional. You can set the permissions (read/Write, read-only, or owner) that the account has to the database when creating an account. You can also grant permissions when modifying permissions or creating databases. Advanced privilege accounts have owner permissions for all databases by default.
New Password
The password must contain 8–32 characters in at least two of the following types: letters, digits, and symbols `_+-&=!@#$%^*()[]`.
Confirm Password
Enter the password again.
Account Remarks
Optional. You can enter remarks, up to 256 characters.
3. After creation, you can perform actions such as Set Permissions, Reset Password, and Delete Account in the account list.
