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>
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and later for Business Suite
Product
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.