This topic describes the features that are supported for security administrators in Data Management (DMS).

Operations in the DMS console

  1. Go to the Sensitive Data tab. On this tab, you can configure data de-identification or masking for sensitive and confidential fields. For more information, see Manage sensitive data.
  2. Go to the Operation Audit tab. On this tab, you can view and audit user operations. For more information, see Operation audit.

Features that are supported for security administrators

Category Feature Description
System management Intelligent operation You can use this feature to view overall information about your DMS tenant, such as statistics about tickets, queries, users, and metadata.
Security management Operation audit Operation logs record data changes. Each record contains information such as the user who performed the operation, operation details, and the time at which the operation was performed. You can use this feature to track historical user operations at any time.
Sensitive data management You can use this feature to manage sensitive data. For example, you can use algorithms to de-identify sensitive data or adjust the sensitivity levels of sensitive data.
Permissions Permission management You can use this feature to apply for permissions on instances, databases, tables, and sensitive fields. You can also view permissions that you have.
SQLConsole Single database query You can write SQL statements to query data in a single database. This feature can be used to verify business code, analyze product effects, and identify issues in an online environment.
Cross-database query You can use this feature to perform join queries across online heterogeneous databases that are deployed in different environments.
Schemas Schema design When you develop or optimize projects or process new business requirements, you can use this feature to change schemas. For example, you can use this feature to create a table or modify an existing table.
Database and table synchronization You can use this feature to compare and synchronize the schemas of tables that are stored in different environments, such as online and offline environments. This feature helps ensure the consistency of schemas.
Optimization SQL review You can use this feature to prevent SQL statements that do not use indexes or do not conform to database development standards. This feature helps protect against SQL injection attacks.
Data plans Data changes You can submit data change tickets to initialize data for a newly published project, clean up historical data, fix bugs, or run a test.
Data import You can submit data import tickets to import a large amount of data to your databases at a time.
Data export You can submit data export tickets to export a large amount of data for analysis or export the required data.
Data tracking If specific data fails to meet your requirements due to reasons such as accidental operations, you can use this feature to restore data to the normal state.
Test data generation Some business scenarios may require you to frequently prepare data. In this case, you can use this feature to generate test data to ensure data security and discreteness, and improve production efficiency.
Data warehouse development DMS uses a database as a compute engine and integrates various tools and services in the database ecosystem, such as Data Transmission Service (DTS) and Data Lake Analytics (DLA), for data warehouse development. You can use this feature to develop and manage data warehouses in DMS with ease.
Data service You can use this feature to export data at the field or row level, display data in a visualized manner, and publish APIs to Alibaba Cloud Marketplace for sale.
Database cloning You can use this feature to clone MySQL databases.