- 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:
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
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.
SAP Adaptive Server Enterprise (ASE) - All versions
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.