This topic describes the permissions of system roles in Data Management (DMS). The system roles are regular user, security administrator, database administrator (DBA), and DMS administrator.

Entry point Category Sub-category Regular user Security administrator Database administrator DMS administrator
Workbench My Tickets N/A Supported Supported Supported Supported
Favorite Databases/Tables N/A Supported Supported Supported Supported
Owned Databases/Tables N/A Supported Supported Supported Supported
Permissions N/A Supported Supported Supported Supported
Recently Used Databases N/A Supported Supported Supported Supported
Updates and Notifications N/A Supported Supported Supported Supported
Quickstart N/A Supported Supported Supported Supported
Permission Access apply Database-Permission Supported Supported Supported Supported
Table-Permission Supported Supported Supported Supported
Sensitive Column-Permission Supported Supported Supported Supported
Database-OWNER Supported Supported Supported Supported
Table-OWNER Supported Supported Supported Supported
Programmable Object Supported Supported Supported Supported
Instance permissions Supported Supported Supported Supported
Permissions N/A Supported Supported Supported Supported
Data Plans Data changes Normal Data Modify Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Lockless change Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
History Data Clean Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Programmable Object Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Import N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Export SQL Result Set Export Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Database Export Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Tracking N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Test Data Generation N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Database Clone N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Factory Task Orchestration N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Warehouse Development N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Service N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Data Visualization N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Schemas Schema Design N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Table synchronization Schema Synchronization Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Empty Database Initialization Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Table consistency repairing Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
Optimization SQL Review N/A Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission) Supported (requires ticket submission)
SQLConsole Single Database Query N/A Supported (requires ticket submission) Supported (requires ticket submission) Globally supported Globally supported
Cross-database Query N/A Supported (requires ticket submission) Supported (requires ticket submission) Globally supported Globally supported
System Management Instances N/A Not supported Not supported Supported Supported
Users N/A Not supported Not supported Not supported Supported
Task N/A Not supported Not supported Supported Supported
Security Security Rules Not supported Not supported Supported Supported
Approval Processes Not supported Not supported Supported Supported
Operation Logs Not supported Supported Not supported Supported
Sensitive Data Not supported Supported Supported Supported
Access IP Whitelists Not supported Not supported Supported Supported
Configuration N/A Not supported Not supported Supported Supported
Database Grouping N/A Not supported Not supported Supported Supported
Intelligent Operation N/A Not supported Supported Supported Supported