SAP Knowledge Base Article - Preview

3764901 - Error 10331 during recovery referencing permission "MANAGE SECURITY CONFIGURATION" - SAP ASE

Symptom

  • After upgrading to ASE 16.1 SP00 PL02
  • When ASE server pre-upgrade server had 'enable granular permissions' enabled
  • ASE errorlog reports the following error during recovery

    Error: 10331, Severity: 14, State: 2
    Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE SECURITY CONFIGURATION.
  • All permissions are properly set for sa

    sp_helpuser
    go

    Users_name ID_in_db Group_name Login_name
    ---------- -------- ---------- ----------
    dbo               1 public     sa

    sp_displaylogin sa
    go -- output truncated

    Suid: 1
    Loginame: sa
    Default Database: master
    Configured Authorization:
            sa_role (default ON)
            sso_role (default ON)


    Read more...

    Environment

    • SAP Adaptive Server Enterprise (ASE) 16.1 SP00 PL02
    • SAP Adaptive Server Enterprise (ASE) 16.1 SP00 PL02 for Business Suite
    • SAP NetWeaver (NW) - All versions 

    Product

    SAP Adaptive Server Enterprise 16.1

    Keywords

    CR 832174, 832174, granular, 10331, permission, recovery, upgrade, upgraded, SP00, PL01, PL02, SP00PL01, SP00PL02,  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error

    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.