When running a Sybase ASE Auditing jobs "Procedure Audit Options" check, the results for specified procedures show as being 'off" (Red Message) in
returned messages when in fact they are "On" in the database.
RHEL 6.4 / Sybase 4.2.0 Modules CCS 11.1
Failures as seen below would be indicative of this problem.
Notice in the below image of the "ASE Procedure Audit Options" template the "Procedure_trigger" is specified as "sp_adduser". This does not qualify as a valid entry for our template.
In order to have the "procedure_trigger" specified return the correct message status of "Green" you must prefix the "procedure_trigger" with "dbo.".
Example of a correct template entry:
Example of a miss configured entry:
This stands true for every "Procedure_trigger" entry.
Subscribing will provide email updates when this Article is updated. Login is required.