Introduction to the permission map of system roles - Data Management

This topic describes the DMS features that each system role can use. The system roles include regular user, security administrator, DBA, DMS administrator, schema read-only user, and technical support.

Home

Level-1 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
My Tickets	Supported	Supported	Supported	Supported	Supported	Supported
Followed Assets	Supported	Supported	Supported	Supported	Supported	Not supported
My Assets	Supported	Supported	Supported	Supported	Supported	Not supported
Accessible Assets	Supported	Supported	Supported	Supported	Supported	Not supported
Recently Accessed Assets	Supported	Supported	Supported	Supported	Supported	Not supported
Release Notes	Supported	Supported	Supported	Supported	Supported	Not supported
Instance List	Supported	Supported	Supported	Supported	Supported	Not supported
Database List	Supported	Supported	Supported	Supported	Supported	Not supported
Logical DB List	Supported	Supported	Supported	Supported	Supported	Not supported
Shortcuts	Supported	Supported	Supported	Supported	Supported	Not supported

Data Assets

Level-1 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
Instance registration	Not supported	Not supported	Supported	Supported	Not supported	Not supported
Use the asset category feature	Supported	Supported	Supported	Supported	Supported	Not supported

SQL Console

Note

Before you perform operations such as queries and changes on databases in the SQL Console or logical data warehouses, make sure that you have the required database permissions.

Level-1 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
SQL Console	Supported	Supported	Supported (globally available)	Supported (globally available)	Supported	Not supported

Security and Disaster Recovery (former DBS)

Level-1 feature module	Level-2 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
Permission center	Permission tickets	Supported	Supported	Supported	Supported	Supported	Not supported
	My Permissions	Supported	Supported	Supported	Supported	Supported	Not supported
	Permission templates	Not supported	Supported	Supported	Supported	Not supported	Not supported
Security rule	-	Not supported	Not supported	Supported	Supported	Not supported	Not supported
Approval processes	-	Not supported	Not supported	Supported	Supported	Not supported	Not supported
IP address whitelist	-	Not supported	Not supported	Not supported	Supported	Not supported	Not supported
Use the operation audit feature	-	Supported	Supported	Supported	Supported	Supported	Not supported
Sensitive data management	Sensitive data assets	Not supported	Supported	Supported	Supported	Not supported	Not supported
	Rule configuration	Not supported	Supported	Supported	Supported	Not supported	Not supported
	Sensitive data audit	Not supported	Supported	Supported	Supported	Not supported	Not supported
Data watermark	-	Supported	Supported	Supported	Supported	Supported	Not supported

Database Development

Note

Database development features are used based on your database permissions. Before you use database ticket features, you must have the required database permissions.

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

Level-1 feature module	Level-2 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
Schema change	Design schemas	Supported	Supported	Supported	Supported	Supported	Not supported
	Synchronize schemas	Supported	Supported	Supported	Supported	Supported	Not supported
	Synchronize shadow tables	Supported	Supported	Supported	Supported	Supported	Not supported
	Initialize empty databases	Supported	Supported	Supported	Supported	Supported	Not supported
	Repair table schema inconsistency	Supported	Supported	Supported	Supported	Supported	Not supported
Data change	Standard data change	Supported	Supported	Supported	Supported	Supported	Not supported
	Lockless change	Supported	Supported	Supported	Supported	Supported	Not supported
	Historical data cleanup	Supported	Supported	Supported	Supported	Supported	Not supported
	Data import	Supported	Supported	Supported	Supported	Supported	Not supported
	Programmable objects	Supported	Supported	Supported	Supported	Supported	Not supported
Data export	Export SQL result sets	Supported	Supported	Supported	Supported	Supported	Not supported
Data export	Database export	Supported	Supported	Supported	Supported	Supported	Not supported
SQL review	SQL review	Supported	Supported	Supported	Supported	Supported	Not supported
Environment construction	Database cloning	Supported	Supported	Supported	Supported	Supported	Not supported
Environment construction	Test data generation	Supported	Supported	Supported	Supported	Supported	Not supported
Data tracking	Data tracking	Supported	Supported	Supported	Supported	Supported	Not supported
R&D workspace	DevOps	Supported	Supported	Supported	Supported	Supported	Not supported
R&D workspace	My Tickets	Supported	Supported	Supported	Supported	Supported	Supported

Data+AI

Level-1 feature module	Level-2 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
Data transmission	Data synchronization	Supported	Supported	Supported	Supported	Supported	Not supported
	Data migration	Supported	Supported	Supported	Supported	Supported	Not supported
	Change tracking	Supported	Supported	Supported	Supported	Supported	Not supported
	Change tracking	Supported	Supported	Supported	Supported	Supported	Not supported
Data development	Task orchestration	Supported	Supported	Supported	Supported	Supported	Not supported
Heterogeneous database migration (ADAM)	Database evaluation	Supported	Supported	Supported	Supported	Supported	Not supported
	Application evaluation and transformation	Supported	Supported	Supported	Supported	Supported	Not supported
	Convert SQL scripts	Supported	Supported	Supported	Supported	Supported	Not supported

Solution

O&M

Level-1 feature module	Regular user	Security administrator	DBA	DMS administrator	Schema read-only user	Technical support
User management	Not supported	Not supported	Not supported	Supported	Not supported	Not supported
Configuration Management	Not supported	Not supported	Not supported	Supported	Not supported	Not supported
Database grouping	Not supported	Not supported	Supported	Supported	Supported	Not supported
Manage tasks	Not supported	Not supported	Supported	Supported	Not supported	Not supported
Notification management	Not supported	Not supported	Supported	Supported	Not supported	Not supported
Intelligent O&M	Not supported	Supported	Supported	Supported	Not supported	Not supported
Task orchestration O&M center	Supported	Supported	Supported	Supported	Supported	Supported