Sybase 4.2 Audit module (Message Based)/ ASE Auditing Module reporting incorrect failure on "Procedure Audit check".

Products

• Control Compliance Suite Unix

Issue/Introduction

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.

Failures as seen below would be indicative of this problem.

Environment

RHEL 6.4 / Sybase 4.2.0 Modules CCS 11.1

Cause

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.

Resolution

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:

"dbo.sp_adduser"

Example of a miss configured entry:

"sp_adduser"

This stands true for every "Procedure_trigger" entry.