Data Management allows you to specify the design of table schemas to ensure the existence of fields, which helps you perform subsequent operations such as data analysis and data scrubbing. This topic describes how to configure security rules to ensure the existence of fields in new tables.

Prerequisites

You are a Data Management (DMS) administrator or database administrator (DBA). For more information about how to view your system role, see View system roles.

Background information

Schema designs may be unique to each enterprise or business line. In most cases, administrators can set the security compliance policies for each instance by using Security Rules in Data Management.

Procedure

  1. Log on to the DMS console V5.0.
  2. In the top navigation bar, choose Security and Specifications > Security Rules.
  3. On the Security Rules page, find the rule that you want to modify and click Edit in the Actions column.
  4. In the left-side menu bar, click Schema Design and click Save Changes and Validate Header.
  5. Edit the original security rule and set the domain-specific language (DSL) for the rule.
    This example shows you how to ensure that the id and gmt_create fields exist in tables. The following DSL syntax is used:
         
         
     
     
    @ act.block_submit "[R&D specifications] The following fields must exist in new tables: id and gmt_create. Non-compliant"
  6. Click Submit.
  7. Click Enable. In the message that appears, click OK.
    Note By default, the rule is disabled. You must enable it before the rule can take effect.
  8. The rule is applicable to R&D scenarios (create tables or import SQL statements to create tables).