Skip to Content

Auditing including SQL text in extrainfo by default? (ASE 16 SP03)

For various types of auditing entries (insert, update, etc), in ASE 16 SP03, we're seeing the SQL text in the extrainfo column (role info too)

That's nice in theory, but it dramatically increases the size of the audit db for high volume applications.

Is there an option to turn this off?

Thanks in advance
Ben

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 01 at 10:13 PM

    Short answer no.

    You can get the data out of sysaudits_xx tables using thresholds + scheduled jobs to any user user defined table. So you can pick and choose what you want to retain/copy. Nice thing is SAP/Sybas has provided upto 8 sysaudits_xx tables to roll the data in a round robin fashion.

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded