This topic describes the permissions of system roles in Data Management (DMS). The system roles are regular user, security administrator, database administrator (DBA), DMS administrator, and schema read-only user.
Home page
| Category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|
| My Tickets | Supported | Supported | Supported | Supported | Supported |
| Followed Assets | Supported | Supported | Supported | Supported | Supported |
| My Assets | Supported | Supported | Supported | Supported | Supported |
| Accessible Assets | Supported | Supported | Supported | Supported | Supported |
| Recently Accessed Assets | Supported | Supported | Supported | Supported | Supported |
| Release Notes | Supported | Supported | Supported | Supported | Supported |
| Instance List | Supported | Supported | Supported | Supported | Supported |
| Database List | Supported | Supported | Supported | Supported | Supported |
| Logical DB List | Supported | Supported | Supported | Supported | Supported |
| Shortcuts | Supported | Supported | Supported | Supported | Supported |
Data Assets
| Category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|
| Global Search | Supported | Supported | Supported | Supported | Supported |
| Instances | Not supported | Not supported | Supported | Supported | Not supported |
| Categories | Not supported | Not supported | Supported | Supported | Supported |
| Asset Dashboard | Not supported | Not supported | Supported | Supported | Not supported |
SQL Console
| Category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|
| SQL Console | Supported (permissions required) | Supported (permissions required) | Supported (with permissions on all features) | Supported (with permissions on all features) | Supported (permissions required) |
| Cross-database Query | Supported (permissions required) | Supported (permissions required) | Supported (with permissions on all features) | Supported (with permissions on all features) | Supported (permissions required) |
Database Development
| Category | Sub-category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|---|
| Schema Change | Schema Design | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Schema Synchronization | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Shadow Table Synchronization | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Empty Database Initialization | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Table Consistency Repairing | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Data Change | Normal Data Modify | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Lockless change | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| History Data Clean | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Data Import | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Programmable Object | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Data Export | SQL Result Set Export | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Database Export | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| SQL Review | SQL Audit Ticket | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Environment Construction | Database Clone | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Test Data Generation | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Data Tracking | Data Tracking Ticket | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| R&D Space | DevOps | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| My Tickets | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
DTS
| Category | Sub-category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|---|
| DTS (DTS) | Data Synchronization | Supported | Supported | Supported | Supported | Supported |
| Data Migration | Supported | Supported | Supported | Supported | Supported | |
| Change Tracking | Supported | Supported | Supported | Supported | Supported | |
| Data integration | Batch Integration | Supported | Supported | Supported | Supported | Supported |
| Streaming ETL | Supported | Supported | Supported | Supported | Supported | |
| Data Development | Task Orchestration | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Data Warehouse Development | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Data Application | Data Service | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) |
| Data Visualization(Old) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | Supported (permissions required) | |
| Heterogeneous Database Migration(ADAM) | Database Evaluation | Supported | Supported | Supported | Supported | Supported |
| Database Transformation and Migration | Supported | Supported | Supported | Supported | Supported | |
| Application Evaluation and Transformation | Supported | Supported | Supported | Supported | Supported | |
| Database Cutover | Supported | Supported | Supported | Supported | Supported | |
| Migration Lab | Supported | Supported | Supported | Supported | Supported | |
| SQL Conversion | Supported | Supported | Supported | Supported | Supported |
Security and Specifications
| Category | Sub-category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|---|
| Permission Center | Permission Tickets | Supported | Supported | Supported | Supported | Supported |
| Permissions | Supported | Supported | Supported | Supported | Supported | |
| Permission template | Not supported | Not supported | Supported | Supported | Not supported | |
| Security Rules | Not supported | Not supported | Not supported | Supported | Supported | Not supported |
| Approval Processes | Not supported | Not supported | Not supported | Supported | Supported | Not supported |
| Access IP Whitelists | Not supported | Not supported | Not supported | Supported | Supported | Not supported |
| Operation Audit | Not supported | Supported | Supported | Supported | Supported | Supported |
| Data Security Center | Not supported | Not supported | Supported | Supported | Supported | Not supported |
| Secure Access Proxy | Proxy List | Not supported | Not supported | Supported | Supported | Supported |
| SQL Audit | Supported | Supported | Supported | Supported | Supported | |
| Sensitive Data | Sensitive Data Assets | Not supported | Supported | Supported | Supported | Not supported |
| Rule Configurations | Not supported | Supported | Supported | Supported | Not supported | |
| Sensitive Data Audit | Not supported | Supported | Supported | Supported | Not supported | |
| Data Watermark | Not supported | Supported | Supported | Supported | Supported | Supported |
Solution
| Category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|
| Data archiving | Supported | Supported | Supported | Supported | Supported |
| One-Click Warehouse Building | Supported | Supported | Supported | Supported | Supported |
| T+1 Full Data Snapshot | Supported | Supported | Supported | Supported | Supported |
| Intelligent Search and Recommendation | Supported | Supported | Supported | Supported | Supported |
| Database Migration | Supported | Supported | Supported | Supported | Supported |
O&M
| Category | Regular user | Security administrator | DBA | DMS administrator | Schema read-only user |
|---|---|---|---|---|---|
| Users | Not supported | Not supported | Not supported | Supported | Not supported |
| Configuration Management | Not supported | Not supported | Not supported | Supported | Not supported |
| Database Grouping | Not supported | Not supported | Supported | Supported | Supported |
| Task | Not supported | Not supported | Supported | Supported | Not supported |
| Notification | Not supported | Not supported | Supported | Supported | Not supported |
| Intelligent Operation | Not supported | Supported | Supported | Supported | Not supported |