SAP Knowledge Base Article - Preview

3195164 - Msg 10331 when modifying a system table, following permission(s) to run this command: MANAGE SECURITY CONFIGURATION for SAP ASE for BS

Symptom

  • In this example, when changing srvclass from 11 (RPCServer) to 7 (ASE Enterprise) using sapsa in sysservers table. 
  • For system tables, allow updates to system tables needs to be set.
  • This error occurs when sapsa is used and has not been granted Manage Security Configuration:
    sp_configure "allow updates", 1
    go
    Msg 10331, Level 14, State 2:
    Server 'SID', Procedure 'sp_configure', Line 1310:
    Permission denied, database master, owner dbo. You need the following
    permission(s) to run this command: MANAGE SECURITY CONFIGURATION.
    (return status = 1)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Keywords

Error 10331, MANAGE SECURITY CONFIGURATION, Msg 10321 , 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.