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

Entry Category Sub-category Common user Security administrator DBA 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)
Lock-Free Data Modify 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 Generate 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 Sync 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)
Repair Table Consistency 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 Instance N/A Not supported Not supported Supported Supported
User 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
Data Protection 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