Lyra Finance 19/01/23 Trust Security Smart Contract Audit Trust Security Lyra Finance Executive summary Findings Severity Security Lyra Finance Introduction Trust Security has conducted an audit at the customer's request. The audit is focused on uncovering security issues and additional bugs contained in the been reviewed. Specifically, close attention has been paid to changes since the recent Sherlock audit. Trust Security Lyra Finance Qualitative analysis Metric Rating Comments

This approach can be thought of as auditing changes to a table. Example 43.4 shows an example of an audit trigger function in PL/pgSQL. Example 43.4. A PL/pgSQL Trigger Function for Auditing This example that any insert, update or delete of a row in the emp table is recorded (i.e., audited) in the emp_audit table. The current time and user name are stamped into the row, together with the type of operation TABLE emp ( empname text NOT NULL, salary integer ); CREATE TABLE emp_audit( operation char(1) NOT NULL, stamp timestamp NOT NULL, userid

This approach can be thought of as auditing changes to a table. Example 40-4 shows an example of an audit trigger procedure in PL/pgSQL. Example 40-4. A PL/pgSQL Trigger Procedure For Auditing This example that any insert, update or delete of a row in the emp table is recorded (i.e., audited) in the emp_audit table. The current time and user name are stamped into the row, together with the type of operation CREATE TABLE emp_audit( operation char(1) NOT NULL, stamp timestamp NOT NULL, userid text NOT NULL, empname text NOT NULL, salary integer ); CREATE OR REPLACE FUNCTION process_emp_audit() RETURNS TRIGGER