Symptom
- Upgraded to ASE 16.0 SP03 PL0x from an earlier SP.
- Configuration "enable granular permissions" is enabled by default (Run value is 1).
- sapsa is the dbo (database owner) of <SID> database.
- sapsa failed to use setuser command to adopt the identity of user SAPSR3 in <SID> database:
1> use <SID>
2> go
1> setuser 'SAPSR3'
2> go
Msg 10331, Level 14, State 2:
Server '<SID>', Line 1:
Permission denied, database <SID>, owner dbo. You need the following permission(s) to run this command: SETUSER.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 for Business Suite or higher version
- SAP Netweaver - All versions
Product
SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions
Keywords
Granular permissions, 10331, error 10331, setuser, SETUSER, Permission denied, enable 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.
SAP Knowledge Base Article - Preview