Symptom
- Need to track deletes on all existing tables
- ASE auditing only has options to audit deletes on individual existing tables or for all tables created in the future.
sp_audit "delete", "all", "default table", "on"
go
- sp_audit for "all" tables is not allowed and fails with 18228 error
1> sp_audit "delete", "all", "all", "on"
2> go
Msg 18228, Level 16, State 1:
Server '<server>', Procedure 'sp_audit', Line 386:
'all' is not a valid object name.
(return status = 1)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) All Versions
Product
SAP Adaptive Server Enterprise all versions
Keywords
auditing, sp_audit. CR 818809, 819909 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
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.