tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for MySQL
    Documentation
    Download PDF

    Modifying Account Permissions

    Last updated: 2023-12-05 17:32:58
    Download PDF

      Operational Scenario

      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.
      
      
      API Name
      Description
      Modifies the permissions of a TencentDB instance account
      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