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

  • A password has been added to sso_role.
  • 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.