This document describes how to create a designated account for a TencentDB for SQL Server instance in the console.
Designated account description
You can create one or multiple designated accounts for a TencentDB for SQL Server single-node (formerly basic edition) or two-node (formerly high availability/cluster edition) instance. Note the following for designated accounts:
A designated account can only view and own the specified database.
For example, account B is created in instance A and designated to have the owner permission of the database db1. Then, when logging in to instance A with designated account B, you can only view the database db1, but you can perform all operations on it.
A designated account can be authorized to multiple databases, but a database can be authorized to only one designated account.
This means that a designated account can have the owner permissions of multiple databases, but a database with owner permission granted to a designated account cannot be authorized to other designated accounts.
Directions
2. On the instance management page, select Account Management > Create Account and enter relevant information in the pop-up window. After confirming that everything is correct, click OK.
|
Account Name | It can contain 1–50 letters, digits, or underscores and must start with a letter.
The account name cannot contain the following keywords or symbols: sysadmin , sp_addsrvrolemember , master , mssql , ## , [|] , , , 。 . , ; , ( | ) , -- . |
Account Type | Designated account description Note: A designated account can only view and own the specified database.
|
Database | Select target databases in the Unauthorized Database list. The selected databases and permissions are displayed under Authorized Database on the right, and the selected databases can be deselected. |
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. |
Remarks | Optional. It can contain up to 256 characters. |
Was this page helpful?