Database Workshop
Database Workshop
Database Workshop
Document
What's new
Announcement
Overview
Billing
Permission management
Quick start
Operation guide
Data management
Data interaction platform
Ticket list
Operation and maintenance management
Enterpise security
Approval workflow
Action trail management
User guide (RDS for MySQL)
Instance list
Data management
SQL window
Database management
Ticket list
Data change ticket
SQL review ticket
Clear table tickets
Data cleanup and archiving ticket
Data import and export ticket
Permission application ticket
Operation and maintenance management
Observation and diagnosis
Session management
Monitoring
Enterprise security management
User guide (veDB for MySQL)
Instance List
Data management
SQL window
Database management
Ticket list
Data change ticket
SQL review ticket
Clear table ticket
Data cleanup and archiving ticket
Data import and export ticket
Permission application ticket
Operation and maintenance management
Observation and diagnosis
Session management
Log management
Enterprise security management
User guide (RDS for PostgreSQL)
Instance list
Data management
SQL window
Ticket list
Data change ticket
SQL review ticket
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (RDS for SQL Server)
Instance list
Data management
Ticket management
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (Cache for Redis)
Instance list
Data management
SQL window
Ticket list
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (Document Database for MongoDB)
Instance list
Data management
SQL window
Ticket management
Permission application ticket
Operation and maintenance management
Enterprise security management
User guide (External instance user guide)
Developer tools
Best practices
API reference
Compliance Agreement
Instance access
SQL task
Operation and maintenance management
Audit log management
Slow log and optimization suggestions
Diagnostics and Snapshots
SQL insights and auditing
Ticket management
Security control
Appendixes
FAQ
FAQ about permission management
Troubleshooting
- Documentation
Database WorkshopUser guide (RDS for MySQL)Data managementTicket listPermission application ticketCreating an operation permission ticket
Copy page
Download PDFPermission application ticket
Creating an operation permission ticket
Copy pageDownload PDFCreating an operation permission ticket
This topic explains how to create a ticket on the Database Workshop (DBW) console to apply for operation permissions on RDS for MySQL instances, databases, tables, and columns.
Prerequisites
Your account is already assigned a DBW role. For detailed steps, refer to the guide for accounts that have been added as or applied to become a DBW role.
Precautions
- Only normal users in DBW can apply for instance operation permissions.
- All administrators in DBW can approve DBW role application tickets.
- The maximum validity period for permissions is 1 year.
- Approvers for operation permission tickets are set in the approval workflow when security control is enabled.
Procedure
- Log on to the DBW console.
- On the top menu bar, select the region.
- On the left navigation bar, select Data management > Ticket list.
- On the Ticket list page, click Create ticket, and select the ticket type you want to create as needed.
- Authorize instanceAuthorize databaseAuthorize tableAuthorize columnIn the dialog box that appears, select Permission application > Authorize instance.ParameterDescriptionApplicantDefaults to the currently logged-in account and can not be modified.Ticket titleOptional. Custom ticket title. The ticket title can not exceed 200 characters.Application typeThe default setting is to Authorize instance, and it cannot be modified.Database typeSelect RDS for MySQL from the drop-down list.Authorize instanceCheck the instance to be authorized from the drop-down list. Multiple selections are supported.Permission typeCheck the permission type as needed. Currently, the following options are supported.
- SQLchange: Refers to operations that add, modify, or delete data in the database. SQL statement types include CREATE, ALTER, DROP, UPDATE, INSERTand DELETE.
- SQL query: Refers to the operation of retrieving the required data from the database. SQL statement types include SELECT, and SHOW .
- Structural change: Represents operations that can modify, add, or delete a database structure. SQL statement types include ALTER TABLE, CREATE INDEX, and DROP INDEX.
- Operation and maintenance read-only: Refers to read-only permissions for operation and maintenance management capabilities, such as viewing real-time sessions and slow SQL analysis lists.
- Operation and maintenance read/write: Refers to full permissions for operation and maintenance management capabilities, such as Kill sessions and creating SQL rate limiting tasks.
Effective timeSelect the valid period for the authorized instance from the drop-down list, with options including 1 month, 3 months, 6 months, and 1 year. Additionally, custom days can be set as the validity period, with a default of 1 day and a range of [1, 365].Ticket remarksCustomize your ticket remarks. We recommend aligning them with your business for easier approval and tracking.In the pop-up dialog, select Permission application > Authorize database.ParameterDescriptionApplicantDefaults to the currently logged-in account and can not be modified.Ticket titleOptional. Custom ticket title. The ticket title can not exceed 200 characters.Application typeDefault is Authorize database and cannot be modified.Database typeSelect RDS for MySQL from the drop-down list.Authorize instanceSelect the instance to authorize from the dropdown list.Authorize databaseSelect the databases to authorize from the drop-down list. Multiple selections are supported.Permission typeCheck the permission type as needed. Currently, the following options are supported.- SQLchange: Refers to operations that add, modify, or delete data in the database. SQL statement types include CREATE, ALTER, DROP, UPDATE, INSERTand DELETE.
- SQL query: Refers to the operation of retrieving the required data from the database. SQL statement types include SELECT, and SHOW .
- Structural change: Represents operations that can modify, add, or delete a database structure. SQL statement types include ALTER TABLE, CREATE INDEX, and DROP INDEX .
Effective timeSelect the valid period for the authorized instance from the drop-down list, with options including 1 month, 3 months, 6 months, and 1 year. Additionally, custom days can be set as the validity period, with a default of 1 day and a range of [1, 365].Ticket remarksCustomize your ticket remarks. We recommend aligning them with your business for easier approval and tracking.In the dialog box, go to Permission application > Authorize table.ParameterDescriptionApplicantDefaults to the currently logged-in account and can not be modified.Ticket titleOptional. Custom ticket title. The ticket title can not exceed 200 characters.Application typeDefault is Authorize database and cannot be modified.Database typeSelect RDS for MySQL from the drop-down list.Authorize instanceSelect the instance to authorize from the drop-down list.Authorize databaseSelect the database to be authorized from the drop-down list.Authorize tableSelect the tables to be authorized from the drop-down list. Multiple selections are supported.Permission typeCheck the permission type as needed. Currently, the following options are supported.- SQLchange: Refers to operations that add, modify, or delete data in the database. SQL statement types include CREATE, ALTER, DROP, UPDATE, INSERTand DELETE.
- SQL query: Refers to the operation of retrieving the required data from the database. SQL statement types include SELECT, and SHOW .
- Structural change: Represents operations that can modify, add, or delete a database structure. SQL statement types include ALTER TABLE, CREATE INDEX, and DROP INDEX .
Effective timeSelect the valid period for the authorized instance from the drop-down list, with options including 1 month, 3 months, 6 months, and 1 year. Additionally, custom days can be set as the validity period, with a default of 1 day and a range of [1, 365].Ticket remarksCustomize your ticket remarks. We recommend aligning them with your business for easier approval and tracking.In the dialog box, select Permission application > Authorize column.ParameterDescriptionApplicantDefaults to the currently logged-in account and can not be modified.Ticket titleOptional. Custom ticket title. The ticket title can not exceed 200 characters.Application typeDefault is Authorize database and cannot be modified.Database typeSelect RDS for MySQL from the drop-down list.Authorize instanceSelect the instance to authorize from the drop-down list.Authorize databaseSelect the database to be authorized from the drop-down list.Authorize tableSelect the table to authorize from the dropdown list.Authorize columnSelect columns to be authorized from the drop-down list. Multiple selections are supported. After selecting the instance, database, table, and column as needed, click Add to include the column permissions in user permissions.Permission typeCheck the permission type as needed. Currently, the following options are supported.- SQLchange: Refers to operations that add, modify, or delete data in the database. SQL statement types include CREATE, ALTER, DROP, UPDATE, INSERTand DELETE.
- SQL query: Refers to the operation of retrieving the required data from the database. SQL statement types include SELECT, and SHOW .
- Structural change: Represents operations that can modify, add, or delete a database structure. SQL statement types include ALTER TABLE, CREATE INDEX, and DROP INDEX .
Effective timeSelect the valid period for the authorized instance from the drop-down list, with options including 1 month, 3 months, 6 months, and 1 year. Additionally, custom days can be set as the validity period, with a default of 1 day and a range of [1, 365].Ticket remarksCustomize your ticket remarks. We recommend aligning them with your business for easier approval and tracking.
- Click Submit application.
Last updated: 2026.08.04 11:16:29
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
