ProData Computer Svcs, Inc., releases SQL Audit, a utility to aid programmers in the evaluation of their SQL results and help satisfy the demand for monitoring the SQL environment.

SQL Audit allows users to track and monitor modifications made to any IBM i database using ProData's SQL/Pro or IBM's SQL. All data inserts, changes and/or deletes are tracked thru journals which can be active only during the execution of each SQL statement or, if journaling is already activated, will use system journal files. SQL Audit also features an interface to display and report these changes for internal audits and compliance tracking.

The SQL Audit interface allows the user to display or extract audit data for viewing or reporting, and to maintain the integrity of the audit files. Users can now log and monitor all database activity from SQL including inserts, changes or deletes.

In addition, ProData's SQL/Pro authority controls offer extensive tailoring on the access of all files and tailoring of the functionality within SQL for each user. SQL Audit creates the tracking and reporting mechanisms necessary for IT audits. This combination allows files to easily be protected from misuse, while special security needs can be tailored as needed by appropriate users.

 

ProData Computer Services, Inc. is a leading provider of IBM i utilities. Founded in July 1981, ProData has been at the forefront in the creation and evolution of software for the IBM i and was one of the first companies to work with the IBM relational database architecture. As a leader in the development of IBM i utilities, ProData utility installations number over 20,000 with distributors located worldwide. ProData has been a part of IBM i Developers Roadmap, IBM’s COMMON America Advisory Council, IBM Advanced Business Partner, and IBM Tools Partner.

To find out more about ProData computer Services, Inc. and its products see their listings in the MC Showcase Buyer's Guide.