Skip to Content
0

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

May 01 at 06:38 PM

39

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Avinash Kothare May 01 at 10:13 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded