SAP Knowledge Base Article - Preview

2402214 - sp_addlogin fails without having ha_role permission - SAP ASE

Symptom

520|0 3 00121436 1 24|DEBUG:QASQL:TCL:4|0:sqlsa command {sp_role   'grant', sa_role, test_login}
520|0 3 00121436 1 25|DEBUG:QASQL:SQL:3|0:sp_role   'grant', sa_role, test_login
520|0 3 00121436 1 26|DEBUG:QASQL:TDS:4|0:{status 1} {servermsg {11105 3 16 {No such user/role 'test_login' exists.}


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sa_role, ha_role, grant, permission, username, loginame, password, fail, sp_addlogin, error, CR744013, CR#744013, 744013 , 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.