Symptom
- 'Full-Text Auditing' is a new feature started from ASE 16.0. Full text with parameter values (local variables / dynamic prepare statements) of DML with option select/insert/update/delete will be printed in column ‘extrainfo’ on sysaudits table.
- When having BOTH configuration parameter 'statement cache size' and 'enable literal autoparam' on, audit record does not show actual value but @@@V0_VCHAR1 / @@@V1_INT etc.
For example: on column ‘extrainfo’ of sysaudits table, it shows full text but no actual parameter values.
event eventmod spid eventtime sequence suid
dbid objid xactid
loginname
dbname
objname objowner
extrainfo nodeid
==========================================================
70 1 20 Oct 26 2016 10:31AM 1 1
4 1328004731 NULL
sa
pubs2
test dbo
sa_role sso_role oper_role sybase_ts_role mon_role; update test set a=@@@V0_INT where b=@@@V1_VCHAR1; ; ; ; ; sa/ase;
NULL
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 and higher
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.