db-admin
Web icon

DB Admin

Stable version 1.2.1 (Compatible with OutSystems 11)
Uploaded
 on 18 December 2025
 by 
5.0
 (1 rating)
db-admin

DB Admin

Details
Enhanced clone of SQL Sandbox with additional audit logging.
Read more

Fork of the SQL Sandbox Forge component that adds:

  • Audit logging
    • This tracks which queries were executed using DB Admin.
    • Audit logging needs to be enabled using the IsAuditLogEnabled site property.
      So this can be disabled on dev and test, allowing anyone to query on dev and test, but enabled on prod, so all prod queries are logged.
  • IP whitelisting
    • Limit access to DB Admin to a limited list of IP addresses.
    • Configure by setting the IPWhitelist site property.
  • Constraint info
      • Use this tool to get information on a database constraint, to get information on the related OutSystems entities and attributes.

        For example, you might get something like the following in an error log:
        ORA-02292: integrity constraint (OSADMIN_OSDEV1.OSFRK_OSUSR_10T_APPLICA2_QKJRB) violated - child record found
        In that case, enter the constraint name (OSFRK_OSUSR_10T_APPLICA2_QKJRB in this case) to get detailed information.

Release notes (1.2.1)
  • Fixed bug on Oracle (thanks to Kurt Vandevelde)
License (1.2.1)
Reviews (1)
by 
2025-05-20
in version 1.0.0
The audit logging is a long waited for improvement. With eg GPDR regulations in mind, the original SQL Sandbox could be used by anyone to tamper with data and nobody would know about it.
This version doesn't give you full tracebility yet to which records were read or modified, but at least we can now check which queries were performe by whom.
Team
Other assets in this category