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 16.0 SP03 PL04 from an earlier SP;
  • Configuration "enable granular permissions" is enabled (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 PL04 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.2

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

  Granular permissions, 10331, error 10331, setuser, SETUSER, Permission denied, enable granular permissions , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.