SAP Knowledge Base Article - Preview

2146162 - sp_addlogin raises error 567 "You must have the following role..." due to password required to set role 'sso_role' on. - SAP ASE

Symptom

  • When trying to login into an ASE server and using a login that have sso_role, getting error 11141:

Msg 11141, Level 16, State 1:
Server '<server_name>':
Password required to set role 'sso_role' on. 

  • If "set role sso_role with passwd 'your_sso_role_password ' on " is not run, then error 567 is raised when one tries to add a new login:

1> sp_addlogin new_login, new_login_password
2> go
 

Msg 567, Level 16, State 1:
Server '<server_name>', Procedure 'sp_addlogin', Line 209:
You must have the following role(s) to execute this command/procedure: 'sso_role'. Please contact a user with the appropriate role for help.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - All versions

Product

SAP Adaptive Server Enterprise all versions

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.