2205978 - Remote user with permission gets login error with procedure | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2205978 - Remote user with permission gets login error with procedure

Symptom

  • The following invalid login error occurs when executing a remote user procedure even though the user has the right permissions:
Could not execute statement.
  Unable to connect to server 'sapserver': [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password
  SQLCODE=-656, ODBC 3 State="HY000"
  Line 1, column 1
  call test_rem.SysRemoteUsersRemote()
Press ENTER to continue...
  • Once a user who owns remote procedure logs in, calling the procedure no longer returns the invalid login error

Read more...

Environment

  • SAP SQL Anywhere 16
  • SAP SQL Anywhere 17

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0

Keywords

client, authentication, log on, asa, anyhwere, extern_login_credential, SQL SECURITY DEFINER, Effective_user , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , BC-SYB-SQA-REM , SQL Anywhere - SQL Remote , Bug Filed

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.