Informix Auditing for Stored Procedure execution
Posted in 2012
NITIN MATHUR — — source: IIUG Forums & Mailing Lists
ello,
I am using IDS 11.70.FC4 on Solaris and I am trying to use Informix auditing
to capture what stored procedures are being used by client applications/jobs
etc. I have created a default mask to capture the event "EXSP". It does a fine
job as long as a user executes a stored procedure. What it fails to capture
is, when the stored procedure executes a different stored procedure within
itself. Am I missing something obvious here?
> onaudit -o -yOnaudit -- Audit Subsystem Configuration Utility
_default - EXSP
> onshowaudit -l
ONSHOWAUDIT Secure Audit Utility
INFORMIX-SQL Version 11.70.FC4
ONLN|2012-08-08
12:18:36.174|tickdb11|27733|i_hamlet|informix|0|EXSP|tickdb|498||||||||
Please help.
regards,
Nitin