2792054 - Execution of DBCC CHECKSTORAGE for sybsecurity database may fail due to error 10331 - SAP ASE for BS

Symptom

When DBCC CHECKSTORAGE is run on Business Suite environment, it may fail due to error 10331. This phenomenon happens when the below conditions fit:

"enable granular permissions" configuration parameter is set to 1
sapsa runs DBCC CHECKSTORAGE for sybsecurity database

isql -Usapsa -P<password> -S<SID> -X

1> dbcc checkstorage(sybsecurity)
2> go
Checking sybsecurity: Logical pagesize is 16384 bytes
Msg 10331, Level 14, State 2:
Server 'SID', Line 1:
Permission denied, database sybsecurity, owner dbo. You need the following permission(s) to run this command: DBCC CHECKSTORAGE.
1>

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and later for Business Suite

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP ERP 6.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2 ; SAP Supplier Relationship Management 7.0 ; SAP Supply Chain Management 7.0

Keywords

DBCC CHECKSTORAGE, enable granular permissions, 10331, sapsa , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.