tencent cloud

All product documents
TencentDB for SQL Server
DocumentationTencentDB for SQL ServerOperation GuideAccount ManagementCreating Designated Account
Creating Designated Account
Download PDF
Last updated: 2024-11-04 11:59:27
Creating Designated Account
Last updated: 2024-11-04 11:59:27
Download PDF
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

1. Log in to the TencentDB for SQL Server console. Click an instance ID or Manage in the Operation column to access the instance management page.
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.

Parameter
Description
Account Name
The account name can contain 1–50 characters, including letters, digits, and underscores (_), and should start with a letter.
It should not contain any of the following reserved keywords: master , mssql , monitor , sys , dbo , dba , sysadmin , tencent_admin , public , securityadmin , serveradmin , setupadmin , processadmin , diskadmin , dbcreator , bulkadmin , administrator (++ ++case insensitive++ ++) , and guest (++ ++case insensitive++ ++).
It should also not contain any of the following sensitive characters: . | ## | ( | ) | [ | ] | , | ``` | ; | ' | " | \ | -- | xp_cmdshell | sp_addsrvrolemember .
Account Type
Designated account description.
Note:
A designated account can only view and own the specified database.
Database
Select a target database in the list under Unauthorized Database. The selected database and related permissions are displayed under Authorized Database on the right side. You can delete the selected database and can also click Unauthorized Database to select all databases in one click.
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?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon