Symptom
- Accessing an object owned by another user returns Error 10330 despite having executed SETUSER
Example:
1> setuser 'SAPSR3DB'
2> go
1> select * from SAPSR3DB.SP_RESULTS
2> go
Msg 10330, Level 14, State 1:
Server 'SID', Line 1:
SELECT permission denied on object SP_RESULTS, database <SID>, owner SAPSR3DB
- Granular permissions are enabled
- User has been granted the OWN DATABASE permission
- User has performed a SETUSER to the owner of the object
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP130 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions (or specific version if related only to a specific SAP Basis)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
10330 granular own setuser, CR#762223, CR 762223, 762223 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.