3680336 - Database audit for insert, update, and delete actions for user SAPSR3 - SAP BS

• Any changes to the database (insert, update, and delete) after login as database schema owner (SAPSR3) need to be audited.
• Error encountered when attempting to audit insert, update, and delete commands using sp_audit and the statement desired. 
  • Example:
    1> sp_audit 'insert','SAPSR3','all','on'
    2> go
    Msg 18225, Level 16, State 1:
    Server '<SID>', Procedure 'sp_audit', Line 410:
    Login name must be 'all'.
    (return status = 1)

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP Adaptive Server Enterprise with Business Suite

audit trail, database audit, adaptive server enterprise, ASE audit, SAPSR3 actions, insert update delete audit, table_access option, audit configuration, archive database, sp_audit, sp_displayaudit, granular audit, audit logs, Sybase ASE , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To