Home
SecurityYou can secure your HCL OneDB™ database server and the data that is stored in your HCL OneDB™ databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
Security in HCL OneDB™The HCL OneDB™ Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
Auditing data security
Audit analysis
Audit analysis with SQL
Preparing audit analysis records for SQL access
Creating a data file for dbload

Creating a data file for dbload

About this task

Procedure

The first step to prepare for SQL-based audit analysis is to use onshowaudit -l to extract selected audit records in dbload format and put them in an output file.

The following example extracts audit records for the user pat from the database server-managed audit file laurel.11 and directs the records to the records_pat output file:

onshowaudit -I -f laurel.11 -u pat -l > records_pat

Important: You must remove the six header lines that are in the output file before you use the file as input for the dbload utility because dbload cannot process the header lines.

The command-line syntax to extract information with onshowaudit is explained in The onaudit utility: Configure audit masks.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.