tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    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.
      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
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy