SAP Knowledge Base Article - Preview

3244699 - Msg 10331 when trying to archive the audit table using select into - SAP ASE for Business Suite

Symptom

  • Try to archive the audit table sybsecurity.dbo.sysaudits_01 to aud_db..audit_data according to KBA 2601042
    select * into audit_data from sybsecurity.dbo.sysaudits_012
    go
  • Error 10331 will be reported:
    Msg 10331, Level 14, State 2;
    Server 'XXX', Line 1;
    Permission denied, database sybsecurity, owner dbo. You need the following permission(s) to run this command: SELECT ANY AUDIT TABLE.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Netweaver - all versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

Keywords

msg 10331, audit table, sysaudits_01, audit_data, SELECT ANY AUDIT TABLE, MANAGE DATABASE PERMISSIONS, granular permissions , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.