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:

    -- 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.