Symptom
- Getting the following error when running installmaster as "sa"
You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Support role and Monitor and Diagnosis role to run the installmaster script.
- sp_displaylogin for sa has proper roles:
sp_displaylogin
go
Suid: 1
Loginame: sa
Fullname:
Default Database: master
Default Language:
Auto Login Script:
Configured Authorization:
sa_role (default ON)
sso_role (default ON)
oper_role (default ON)
sybase_ts_role (default ON)
mon_role (default ON)
sa_serverprivs_role (default ON)
- sp_activeroles does not show mon_role as active:
sp_activeroles
go
Role Name
------------------------
sa_role
sso_role
oper_role
sybase_ts_role
sa_serverprivs_role
(5 rows affected)
(return status = 0)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
activate role, missing role, permissions, mon role, installmaster fails, system tables, monitoring tables , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.