Informix Auditing

Posted in 2015

Topics: SQL Development & Query Writing, Security, Permissions & Auditing

ABRAR RASHID — Mon, 01 Jun 2015 05:35:18 — source: IIUG Forums & Mailing Lists

Hi, I want to verify auditing status by using sql query. can any one provide me list of table used for audit. Thanks.

↪ replying to ABRAR RASHID

Ricardo Henriques — Mon, 01 Jun 2015 09:27:56 — source: IIUG Forums & Mailing Lists

The sysadtinfo@sysmaster table contains information about the auditing configuration for the database server, it's a single row table that provides the same information that the onaudit -c gives you. The sysaudit@sysmaster, for each defined audit mask (for each username), contains flags that represent the database events that generate audit records. The success and failure columns represent the bitmasks that compose the audit masks. If a bit is set in both the success the and failure columns, the corresponding event generates an audit record whether or not the event succeeded. This is the same information you get when run onaudit -o, but you'll have to decode the bitmasks used. Keen regards. On Mon, 1 Jun 2015 at 06:35 ABRAR RASHID <mabrar@i2cinc.com> wrote: > Hi, > > I want to verify auditing status by using sql query. can any one provide me > list of table used for audit. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d043c81707c216505177170bf

↪ replying to ABRAR RASHID

Art Kagel — Mon, 01 Jun 2015 14:21:08 — source: IIUG Forums & Mailing Lists

Look to the sysadtinfo and syscrtadt tables in sysmaster. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Jun 1, 2015 at 1:35 AM, ABRAR RASHID <mabrar@i2cinc.com> wrote: > Hi, > > I want to verify auditing status by using sql query. can any one provide me > list of table used for audit. > > Thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f90ea48374305177589c5