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.
SAP Knowledge Base Article - Preview