SAP Knowledge Base Article - Preview

2809746 - Cannot drop or create a role; errors 11116 and 11165 - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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.