tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Configuration Change
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary

Modifying Account Permissions

PDF
フォーカスモード
フォントサイズ
最終更新日: 2026-02-10 10:28:15
You can authorize and manage existing database accounts via the console, granting them global privileges or object-level privileges, while simultaneously being able to revoke their authorizations.

Account Permissions Overview

Permission name
Description
ALTER
Modify the structure of tables in the database, including permissions for altering table fields, adding table fields, deleting table fields, as well as creating and removing table indexes.
ALTER ROUTINE
Privileges to alter routines such as stored procedures and functions.
CREATE
Privileges to create new objects such as databases, tables, views, stored procedures, and functions.
CREATE ROUTINE
Privileges to create routine objects such as stored procedures and functions.
CREATE TEMPORARY TABLES
Privilege to create temporary tables.
CREATE VIEW
Privilege to create view objects.
DELETE
Privilege to delete data from specified tables.
DROP
Privilege to drop objects such as databases, tables, views, stored procedures, and functions.
EVENT
Privilege to create, modify, and delete events.
EXECUTE
Privilege to execute existing objects such as stored procedures and functions.
INDEX
Privilege to create and delete indexes.
INSERT
Privilege to insert/write new data into tables.
LOCK TABLES
Privilege to lock specified data tables for read/write operations.
REFERENCES
Privilege to create or drop foreign key constraints within the current database.
RELOAD
Privilege to reload some configuration files of the system, restart or shutdown the database, and perform other operations.
REPLICATION CLIENT
Privilege to view and manage the status and parameters of replication processes.
REPLICATION SLAVE
Privilege to replicate data from the MASTER server.
SELECT
Privilege to query data from specified tables.
SHOW DATABASES
Privilege to display all databases within the current database server.
SHOW VIEW
Privilege to display views.
SYSTEM_VARIABLES_ADMIN
Privilege to modify system variables.
TRIGGER
Privilege to create and manage triggers.
UPDATE
Privilege to update data in specified tables.

Operation Steps

1. Log in to the TDSQL Boundless Console, click the Instance List or  in the Operation column in the Manage to go to the Instance Management page.
2. Select the Account Management tab, in the row of the account, click Modify Permissions in the Operation column.
3. On the Modify Account Permissions page, select the database permissions. You can click Preview Modification and then click Modify if no errors exist.
Global Privileges: Possesses all permissions for all databases under the instance.
Object-Level Privilege: Possesses permissions for specific databases under the instance.


ヘルプとサポート

この記事はお役に立ちましたか?

フィードバック