SAP Knowledge Base Article - Preview

2663238 - Msg 10331 Permission denied, You need the following permission(s) to run this command: SETUSER - SAP ASE on Business Suite

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.