SAP Knowledge Base Article - Preview

2975656 - Audit records aren't written for some system procedures on environments with security option for audit - SAP ASE

Symptom

Even if "security" option for audit have configured, Audit records of some system procedures are not written.

for example

  1. Enable security option for audit

    1> use sybsecurity
    2> go
    1> sp_audit 'security', 'all', 'all', 'on'
    2> go

  2. Run sp_addalias

    1> use testdb
    2> go
    1> sp_addalias UserA, UserB
    2> go

  3. Select audit table

    1> use sybsecurity
    2> go
    1> select * from sysaudits_01
    2> go

    (0 rows affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR822961 , CR#822961 , 822961 , sp_dropalias, missing , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.