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.