Permissions of system roles - Data Management - Alibaba Cloud Documentation Center

This topic describes the features that are supported by the system roles of Data Management (DMS). The system roles are regular user, security administrator, database administrator (DBA), DMS administrator, and schema read-only user.

Home page

Category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
My Tickets	Supported	Supported	Supported	Supported	Supported
Followed Assets	Supported	Supported	Supported	Supported	Supported
My Assets	Supported	Supported	Supported	Supported	Supported
Accessible Assets	Supported	Supported	Supported	Supported	Supported
Recently Accessed Assets	Supported	Supported	Supported	Supported	Supported
Release Notes	Supported	Supported	Supported	Supported	Supported
Instance List	Supported	Supported	Supported	Supported	Supported
Database List	Supported	Supported	Supported	Supported	Supported
Logical DB List	Supported	Supported	Supported	Supported	Supported
Shortcuts	Supported	Supported	Supported	Supported	Supported

Data Assets

Category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
Instances	Not supported	Not supported	Supported	Supported	Not supported
Categories	Supported	Supported	Supported	Supported	Supported

SQL Console

Note

Before you perform operations such as query and change operations on a database on the SQL Console page or by using the logical data warehouse feature, make sure that you have the required permissions on the database.

Category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
SQL Console	Supported	Supported	Supported (with permissions on all features)	Supported (with permissions on all features)	Supported

Database Development

Note

You can use the database development feature to develop databases based on your permissions on databases. Before you create tickets to manage a database, you must have the required permissions on the database.

For example, if you want to use the test data generation feature to insert 100,000 test data records into the test_table table of the example database, you must have the change permission on the example database or the test_table table.

Category	Sub-category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
Schema Change	Schema Design	Supported	Supported	Supported	Supported	Supported
	Schema Synchronization	Supported	Supported	Supported	Supported	Supported
	Shadow Table Synchronization	Supported	Supported	Supported	Supported	Supported
	Empty Database Initialization	Supported	Supported	Supported	Supported	Supported
	Table Consistency Repairing	Supported	Supported	Supported	Supported	Supported
Data Change	Normal Data Modify	Supported	Supported	Supported	Supported	Supported
	Lockless Change	Supported	Supported	Supported	Supported	Supported
	Historical Data Cleanup	Supported	Supported	Supported	Supported	Supported
	Data Import	Supported	Supported	Supported	Supported	Supported
	Programmable Object Permissions	Supported	Supported	Supported	Supported	Supported
Data Export	SQL Result Set Export	Supported	Supported	Supported	Supported	Supported
Data Export	Database Export	Supported	Supported	Supported	Supported	Supported
SQL Review	SQL Audit Ticket	Supported	Supported	Supported	Supported	Supported
Environment Construction	Database Clone	Supported	Supported	Supported	Supported	Supported
Environment Construction	Test Data Generation	Supported	Supported	Supported	Supported	Supported
Data Tracking	Data Tracking Ticket	Supported	Supported	Supported	Supported	Supported
R&D Space	DevOps	Supported	Supported	Supported	Supported	Supported
R&D Space	My Tickets	Supported	Supported	Supported	Supported	Supported

DTS

Category	Sub-category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
DTS (DTS)	Data Synchronization	Supported	Supported	Supported	Supported	Supported
	Data Migration	Supported	Supported	Supported	Supported	Supported
	Change Tracking	Supported	Supported	Supported	Supported	Supported
	Data Verification	Supported	Supported	Supported	Supported	Supported
Data Development	Task Orchestration	Supported	Supported	Supported	Supported	Supported
Heterogeneous Database Migration (ADAM)	Database Evaluation	Supported	Supported	Supported	Supported	Supported
	Application Evaluation and Transformation	Supported	Supported	Supported	Supported	Supported
	SQL Conversion	Supported	Supported	Supported	Supported	Supported

Security and Specifications

Category	Sub-category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
Permission Center	Permission Tickets	Supported	Supported	Supported	Supported	Supported
	Permissions	Supported	Supported	Supported	Supported	Supported
	Permission Templates	Not supported	Supported	Supported	Supported	Not supported
Security Rules	-	Not supported	Not supported	Supported	Supported	Not supported
Approval Processes	-	Not supported	Not supported	Supported	Supported	Not supported
Access IP Whitelist	-	Not supported	Not supported	Not supported	Supported	Not supported
Operation Audit	-	Supported	Supported	Supported	Supported	Supported
Sensitive Data	Sensitive Data Assets	Not supported	Supported	Supported	Supported	Not supported
	Rule Configurations	Not supported	Supported	Supported	Supported	Not supported
	Sensitive Data Audit	Not supported	Supported	Supported	Supported	Not supported
Data Watermark	-	Supported	Supported	Supported	Supported	Supported

Solution

O&M

Category	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user
Users	Not supported	Not supported	Not supported	Supported	Not supported
Configuration Management	Not supported	Not supported	Not supported	Supported	Not supported
Database Grouping	Not supported	Not supported	Supported	Supported	Supported
Task	Not supported	Not supported	Supported	Supported	Not supported
Notification	Not supported	Not supported	Supported	Supported	Not supported
Intelligent Operation	Not supported	Supported	Supported	Supported	Not supported
Task Orchestration Operation Center	Supported	Supported	Supported	Supported	Supported