All Products
Search
Document Center

Data Management:Permissions of system roles

Last Updated:Jun 25, 2023

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

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