Ledger Management

Overview

The Ledger Table Policy is a concept that allows important tables within a database to be managed as ledgers. For tables managed as ledgers, users are required to go through a workflow approval process before executing DML queries.

The existing ledger table policy feature was provided as a separate license, but starting from version 10.2.1, it is offered as part of the DAC integration feature.

Administrators can configure the ledger (Ledger) settings at the table level through the Ledger Table Policy menu. By mapping a "Ledger Approval Rule" to the table, the table will be subject to the ledger workflow process. Once the ledger approval rule is mapped, the table will immediately adopt the characteristics of a ledger table.

• When a user attempts to execute an INSERT, UPDATE, or DELETE query on a ledger table:

  • If the user attempts to modify the table using the QueryPie Web Editor or a third-party editor, they will be notified that they need to go through an SQL Request process.

  • Once in the SQL Request, the user will only be able to select the ledger-specific approval rule(s) set by the administrator for that table. The approval process will be enforced based on the table, and approval lines can also be forced.

• When a user attempts to execute a SELECT query on a ledger table:

  • If the user runs a SELECT query on a ledger table using the QueryPie Web Editor, they will be required to enter a reason for executing the query.

  • However, enforcing the input of a reason is not possible in third-party editors.

Access to Ledger Management Guide