Symptom
After running sybmigrate, syssrvroles is not as expected and a role cannot be dropped or created:
drop role my_select_role with override
go
Msg 11116, Level 16, State 1
Server 'ASE', Line 1
Cannot drop role or login 'my_select_role' because it does not exist in this server.
create role my_select_role
go
Msg 11165, Level 16, State 1
Server 'ASE', Line 1
A user, group, login or login profile with the name 'my_select_role' already exists in this server.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
Product
Keywords
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.