SAP Knowledge Base Article - Preview

2830456 - Error 18228 trying to audit deletes on "all" tables - ASE

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.