Configure approval processes for test data generation tickets in Data Management (DMS). Security rules under the Approval Rule Validation checkpoint control whether a ticket requires approval, which approval template applies, or whether the operation is blocked entirely.
How it works
When a user submits a test data generation ticket, DMS checks whether the ticket conforms to the rules specified under the Approval Rule Validation checkpoint. If no rule matches, the default approval template takes effect.
Key concepts
Checkpoints
A checkpoint is the evaluation stage at which DMS applies security rules. Test data generation tickets are evaluated at the Approval Rule Validation checkpoint.
Factors
A factor is a predefined variable that DMS evaluates as part of a security rule condition. You can use factors to obtain the context to be validated by security rules, such as the categories of SQL statements and the number of data rows to be affected. Factor names use the prefix @fac. followed by the display name.
The following factors are available for the Approval Rule Validation checkpoint in Test Data Generation:
| Factor | Description | Example values |
|---|---|---|
@fac.env_type | The environment type of the target database instance. For a full list of environment types, see Change the environment type of an instance. | DEV, PRODUCT |
@fac.schema_name | The name of the target schema. | my_schema |
Actions
An action defines what DMS does when a rule's if condition is met. Examples of actions include: forbids the submission of a ticket, selects an approval process, approves a ticket, or rejects a ticket. Action names use the prefix @act. followed by the display name.
The following actions are available for the Approval Rule Validation checkpoint in Test Data Generation:
| Action | Description |
|---|---|
@act.forbid_submit_order | Blocks ticket submission. Format: @act.forbid_submit_order 'Reason for blocking' |
@act.do_not_approve | Assigns an approval template by its ID. For details, see Configure approval processes. |
Template database
DMS includes a set of predefined security rule templates for Test Data Generation. Enable or modify these templates to match your requirements:
No approval for test databases
Disable test data generation
Forbid test data generation for production databases
Modify the default approval template
The default approval template applies to any test data generation ticket that does not match a custom rule. Modify it to change the approval process used as the fallback.
Prerequisites
Before you begin, ensure that you have:
Access to the DMS console V5.0
Permission to edit security rule sets
Steps
Log on to the DMS console V5.0.
-
Move the pointer over the
icon in the upper-left corner and choose . NoteIf you use the DMS console in normal mode, choose in the top navigation bar.
Move the pointer over the
icon in the upper-left corner and choose All functions > Security and Specifications > Security Rules.If you are using the DMS console in normal mode, choose Security and Specifications > Security Rules in the top navigation bar.
Find the rule set for the target database and click Edit in the Actions column.
On the Details page, in the left-side navigation pane, choose Database Development > Test Data Generation.
Find the Default Template for Test Data Generation rule and click Edit in the Actions column.
In the Change Configuration Item dialog box, click Switch Approval Template.
In the Switch Approval Template dialog box, find the target approval template and click Select in the Actions column.
To skip approval for all tickets that fall back to this template, click Reset to Free of Approval instead.
Click Submit.
Create an approval rule
Create a custom rule to control approval behavior for specific conditions—such as blocking test data generation for production databases or requiring a specific approval process for certain schemas.
Prerequisites
Before you begin, ensure that you have:
Access to the DMS console V5.0
Permission to edit security rule sets
Steps
Log on to the DMS console V5.0.
-
Move the pointer over the
icon in the upper-left corner and choose . NoteIf you use the DMS console in normal mode, choose in the top navigation bar.
Move the pointer over the
icon in the upper-left corner and choose All functions > Security and Specifications > Security Rules.If you are using the DMS console in normal mode, choose Security and Specifications > Security Rules in the top navigation bar.
Find the rule set for the target database and click Edit in the Actions column.
On the Details page, in the left-side navigation pane, choose Database Development > Test Data Generation.
Under Checkpoints, select Basic Configuration Item, and then click Create Rule. Configure the following items:
Configuration item Required Description Checkpoints Yes Select Approval rule validation. Template database No Load a predefined rule template. After selecting a checkpoint, click Load from Template Database to browse available templates. For descriptions of each template, see Template database. Rule name Yes A name for the rule. If you load a template, the name is filled in automatically. Rule DSL Yes The DSL statement that defines the rule logic. If you load a template, the statement is filled in automatically. For DSL syntax, see DSL syntax for security rules. Click Submit.
Enable the rule. New rules are Disabled by default. Click Enable in the Actions column, and then click OK.
What's next
DSL syntax for security rules — write custom DSL conditions using the factors and actions listed above.
Configure approval processes — set up the approval templates referenced by
@act.do_not_approve.Change the environment type of an instance — manage the
@fac.env_typevalues available in your rules.