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:
-- object level
use database
go
sp_audit "delete", "all", "table_name", "on"
go
-- 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
sp_audit "delete", "all", "all", "on"
go
Msg 18228, Level 16, State 1:
Server '<server>', Procedure 'sp_audit', Line 386:
'all' is not a valid object name.
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.
SAP Knowledge Base Article - Preview