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 |