Advanced query history
Query history captures details about the user activity on the IBM® Netezza® system, such as the queries that are run, query plans, table access, column access, session creation, and failed authentication requests. This section describes the advanced query features used with the new security capabilities.
History information is saved in a history database. Users with
the correct privileges can review the query history information for
details about the users and activity on the Netezza system.
These features enhance the query history with auditing and the following
benefits:
- Guaranteed audit capture of all operations
- Digital signing of audit data
- Audit data stored in row-secure tables
- Secure data offload to a different Netezza system, lowering the impact on a production system and improving the security of the audit
For more information about query history, see the IBM Netezza System Administrator’s Guide.