Manage Approval Process

By default, NineData provides SQL approval processes in both development and production environments to ensure the security of databases. You can also customize approval processes based on your business needs.

Notes

• The creation of a new process must be based on an existing process.
• The default process provided by the system cannot be deleted but can be edited.
• In the DevOps Pro edition, creating processes is not supported, while the DevOps Enterprise edition has no such limitation.

Prerequisites

• You have created or joined an organization, and this organization has subscribed to either DevOps Pro or DevOps Enterprise. Please ensure that your annual or monthly subscription is still active. For more information, please refer to Manage Organizations.
• Your current account has switched to the target organization. For more information, please refer to Switching to an Organization.

• Your role in the organization is a Administrator.

No Specified Approver

A new switch Not Specifying Approvers has been added to the approval process page. When this switch is turned on, all work orders using the current approval process will not require a specific approver to be designated. Instead, all personnel with approval privileges will receive approval notifications. This feature is useful in scenarios where designated approvers are unable to process approvals promptly, leading to important tasks not being completed within the specified timeframe.

Create a Process

1. Log in to the NineData console.

2. In the left navigation pane, click DevOps>Policy & Process.

3. On the Policy & Process page, click the Approval Process tab, and click Create Process in the upper-right corner.

   tip

   You can also click Duplicate in the Actions column to create a new process based on an existing process.

4. In the Create Process dialog box that appears, configure the following parameters and click OK.

   • Duplicate Process: Select which process to use as the basis for the new process.

     tip

     If you arrived at this dialog box by clicking Duplicate, this is already pre-selected.

   • Name: Enter a name for the new process, supporting 1~32 characters. To facilitate future searches and management, please use a meaningful name as much as possible.

     tip

     If you arrived at this dialog box by clicking Duplicate, this is already filled in.

   • Description (optional): Enter a description for the new process, supporting 1~64 characters.

5. The console will automatically redirect to the Details page, where you can edit approval processes for various tasks. The Not Specifying Approvers feature at the top of the page allows users to submit work orders without manually selecting an approver. Instead, all personnel with approval privileges will receive approval notifications.

   The approval processes are categorized into several major types, including SQL Task, Apply Permission, Data Export, Data Import, and SQL Code Review. You can switch between these categories by clicking on the corresponding tabs. Clicking on the Edit button next to the target approval process allows you to enter the editing page. The general parameters are explained below.

   Parameter	Description
   Approve Manager	Choose whether to allow users to submit the approval process. Allow to Submit: Allows users to advance the approval process to the next level. NOT Allow to Submit: Blocks the user's approval process, preventing further advancement.
   Enable Process	When Approve Manager is set to Allow to Submit, you can choose whether to enable the approval process. Turned on: Approval processes submitted by users must undergo manual approval. Turned off: Users do not need manual approval; the approval process proceeds directly.
   Approval Process	When the Enable Process switch is on, click the Add button to add an approval node. Clicking the Add button multiple times adds multiple approval nodes. Enter the name of the approval node in the left text box and select the approver for that node on the right. Click the icon next to the approval node to delete it.

Edit a Process

1. Log in to the NineData console.
2. In the left navigation pane, click DevOps>Policy & Process.
3. On the Policy & Process page, click the Approval Process tab, and then click the target Name.
4. The console will switch to the Details page, where you can edit the approval process when various rule levels are triggered.

Delete a Process

1. Log in to the NineData console.

2. In the left navigation pane, click DevOps > Policy & Process.

3. On the Policy & Process page, click the Approval Process tab.

4. Click on the process to be deleted, and on the Details page, click Delete at the upper right corner.

   tip

   You can also click Delete in the Actions column on the right side of the target process.

5. In the confirmation window that pops up, click Delete.

   tip

   If the current process is already associated with an environment or data source, you need to select a new process for these resources in the Associated envir. and datasources existed, Please modify first. window that pops up, and then click Modify and Delete.

Associating Process with Environment

When an approval process is associated with an environment, it will overwrite the original process in the environment, and the new process will apply to all data sources under the environment.

1. Log in to the NineData console.
2. In the left navigation pane, click DevOps > Policy & Process.
3. On the Envir. Config tab, find the target environment name and click Edit in the Actions column on the right side.
4. In the Edit Envir. Config window that pops up, select the Approval Process that you need and click OK.

Associating Process with Data Source

When an approval process is associated with a data source, the data source will apply the new process instead of the process under the corresponding environment. Other data sources under the same environment are not affected.

1. Log in to the NineData console.

2. In the left navigation pane, click DevOps > Policy & Process.

3. Click the Datasource Config tab, find the target data source name, and click Edit in the Actions column on the right side.

   tip

   In the Approval Process associated with the data source, the icon on the left indicates that Approval Process has inherited the configuration in the environment.

4. In the pop-up window Edit Datasource Config, uncheck the box on the left of Inheriting Envir. Config under Approval Process, and then select the Approval Process you need, and click on OK.

   tip

   To restore the Approval Process configured in the environment, simply reselect Inheriting Envir. Config.

Linking Processes to Database Groups

Database groups are used for unified table changes across distributed databases. Once an approval process is linked to a database group, this group will use the specified process instead of the process set for the environment. Other data sources in the environment will not be affected.

1. Log in to the NineData Console.

2. In the left navigation bar, click DevOps > Policy & Process.

3. Click the DB Group Config tab, find the target database group name, and click Edit in the Actions column on its right side.

   In the Approval Process linked to the database group, icons like on the left indicate inherited Approval Process from the environment configuration.

4. In the pop-up Edit Group Config window, uncheck the box to the left of Inheriting Envir. Config under Approval Process. Then select the desired Approval Process and click OK.

   Rechecking Inheriting Envir. Config will restore the Approval Process configuration inherited from the environment.