TencentDB for SQL Server supports creating and deleting accounts and modifying account permissions on the Manage Account page in the console. Such operations cannot be performed in Microsoft SQL Server Management.
The created account name and password will be used when connecting to TencentDB for SQL Server. Please store them properly.
Log in to the TencentDB for SQL Server Console and click an instance name or Manage in the "Operation" column to enter the instance management page.
Select Manage Account > Create Account and enter relevant information in the pop-up dialog box. After confirming that everything is correct, click OK.
There are three types of account permissions in TencentDB for SQL Server:
- Admin: by default, it has read/write permissions to all databases. Only one admin account can be set for one instance.
- Read/Write: it has read/write permissions to authorized databases and can perform database changes.
- Read-only: it has read-only permission to only authorized databases and cannot perform changes.
After the account is created, you can perform operations such as Remove Admin, Modify Permissions, Reset Password, and Delete Account in the account list.