You have the capability to manage existing database accounts through the MySQL Cloud Database Console, granting them either global privileges or object-level privileges. Concurrently, you also possess the ability to revoke these authorizations.
Account Authorization Description
Authorization
Description
ALTER
The authority to alter the structure of tables within the database, encompassing the modification of table fields, the addition and deletion of table fields, as well as the creation and removal of table indices.
ALTER ROUTINE
Modify the permissions of routines such as stored procedures and functions.
CREATE
The authority to create new objects such as databases, tables, views, stored procedures, and functions.
CREATE ROUTINE
The authority to create routine objects such as stored procedures and functions.
CREATE TEMPORARY TABLES
The authorization to create temporary tables.
CREATE USER
This authority allows for the creation of new users and the allocation of corresponding permissions to them.
CREATE VIEW
The authority to create view objects.
DELETE
The authority to delete data from a specified table.
DROP
The authority to delete objects such as databases, tables, views, stored procedures, and functions.
EVENT
The authority to create, modify, and eradicate events.
EXECUTE
This authority permits users to execute pre-existing objects such as stored procedures and functions.
INDEX
The authority to create and eradicate indices.
INSERT
The authority to insert or write new data into the table.
LOCK TABLES
Securing the requisite permissions for executing read and write operations on the designated data table.
PROCESS
The authority to view the information of all currently active threads and processes.
REFERENCES
The authority to create or remove foreign key constraints within the current database.
RELOAD
The authority to reload certain system configuration files, as well as to restart or shut down the database.
REPLICATION CLIENT
Authority to observe and administer the status and parameters of the replication process.
REPLICATION SLAVE
The authority to replicate data from the Master server.
SELECT
The authority to query data from the designated table.
SHOW DATABASES
Display the permissions of all databases in the current database server.
SHOW VIEW
Displaying the permissions of the view.
TRIGGER
Authority to create and administer triggers.
UPDATE
Permission to update data in a specified table.
Directions
1. Log in to the TencentDB for MySQL console. In the instance list, click the instance ID or Manage in the Operation column to access the instance management page.
2. Select the Database Management > Account Management tab, find the account for which to modify the permissions, and click Modify Permissions.
3. In the pop-up dialog box, select or deselect permissions and click OK to complete the modification.
Global Privileges: Grant global permissions to all databases in the instance.
Object-Level Privileges: Grant permissions to certain databases in the instance.
Yes
No
Was this page helpful?