Release Notes
Product Announcements
Deleting Account
Overview
To disable a created database account, you can delete it in the TencentDB for SQL Server console.
Note:
In order to avoid accidental deletion from interrupting normal use by your business, you need to make sure that the database account to be deleted is no longer used by any applications.
If Agent JOBs have been created for an account, they will be concurrently deleted when the account is deleted. Therefore, prior to the deletion of an account possessing Agent JOBs, it is necessary to transfer the ownership of all Agent JOBs to other accounts.
Instructions for Sensitive Operations with MFA Integrated
To enhance the security of the cloud account, TencentDB for SQL Server supports MFA (Multi-Factor Authentication), which brings an extra layer of protection in addition to the username and password. After the MFA device verification is enabled, when you perform operations such as destroying instances/changing network/modifying IP addresses/resetting passwords/deleting accounts/resetting instances/performing primary-replica switch, a second identity verification based on the MFA dynamic code will be conducted. Such operations can be executed only after successful verification. For an introduction to MFA and how to enable the operation protection, see MFA Devices.
Administrator Removal Instructions
If the account type is privileged account or admin account, you need to first remove the administrator from the account before deleting it. After the administrator is removed, the account will be downgraded to a standard account and have owner permissions for all databases under the instance by default. The steps to remove the administrator are as follows.
1. On the instance management page, select the Account Management page, select the target account, and click Remove Administrator in the Operation column.
2. In the pop-up dialog box, click OK.
Directions
1. Log in to the TencentDB for SQL Server console. In the instance list, click an Instance ID or Manage in the Operation column to enter the instance management page.
2. On the instance management page, select the Manage Account tab, select the target account, and click Delete Account in the Operation column.
Note：
Batch account deletion is supported. After multiple target accounts are selected, choose Batch Management > Batch Delete.
3. In the pop-up window, confirm the information and click Delete.
Related APIs
API | Description |
This API is designed for the purpose of deleting instance accounts. |
フィードバック