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 |