Data Management (DMS) provides the metadata access control feature. You can enable this feature to allow only users who have permissions on an instance or a database to view information about and access the instance or database. This topic describes how to enable metadata access control for an instance or a database in DMS.

Prerequisites

The control mode of the database instance is Security Collaboration.

Background information

After you enable metadata access control for an instance or a database, only users who have permissions on the instance or database can view information about and access the instance or database. This further enhances data security.
Note In DMS, permissions on an instance or a database include the query, export, and change permissions. If you have one of these permissions on an instance or a database, you have permissions on the instance or database. You can view the following information if you have permissions on a database:
  • Information about the database. You can search for the database in the search box at the top of the left-side navigation pane or in the search box at the top navigation bar. You can also search for the database in the search box on the Permission Application Ticket page.
  • Information about the instance to which the database belongs.

Procedure

  1. Go to the DMS console V5.0.
  2. In the top navigation bar, click Data Assets. In the left-side navigation pane, click Instances.
  3. Enable metadata access control for an instance or a database.
    • To enable metadata access control for an instance, perform the following steps:
      1. Click the Instance List tab.
      2. Find the database instance for which you want to enable metadata access control, move the pointer over More in the Actions column, and then select Access control.
      3. In the Metadata access control dialog box, turn on Metadata access control and click OK.
    • To enable metadata access control for a database, perform the following steps:
      1. On the Instances page, click the Database List tab.
      2. Find the database for which you want to enable metadata access control, move the pointer over More in the Actions column, and then select Access control.
      3. In the Metadata access control dialog box, turn on Metadata access control and click OK.