Ledger Management

Overview

Ledger table policy is a concept that allows you to manage important tables in a database as ledgers. For tables managed as ledgers, you can force users to go through a workflow approval process to execute DML queries.

Administrators can set up ledgers at the table level of databases through the Ledger Table Policy menu. When a ‘Ledger-specific Approval Rule’ is mapped to a table, it goes through the ledger workflow process. By mapping a ledger-specific approval rule, the table immediately takes on the characteristics of a ledger table.

• When a user executes INSERT / UPDATE / DELETE queries on a ledger table:
  • When a user attempts to execute modification queries in QueryPie Web Editor or 3rd-party editors for that table, the user will be notified that they must go through SQL Request.
  • Users who then enter SQL Request can only select the ledger-specific approval rule (Ledger Approval Rule) that the administrator has previously set for that table. This forces approval based on the table and simultaneously enforces the approval line.
• When a user executes SELECT queries on a ledger table:
  • When a user executes SELECT queries in QueryPie Web Editor for a ledger table, they can be forced to enter a reason for performing the query.
  • However, reason input cannot be forced in 3rd-party editors.

Ledger Management Guide Quick Links

• Ledger Table Policy
• Ledger Approval Rules