Skip to Content
Sep 23, 2016 at 01:16 PM

Privilegs of remote procedures after upgrade


Hi SQL Anywhere Community,

could anyone help me?

We use Proxy Server between two ASA databases for few years and it worked fine. After upgrade to version ASA 16 application gets SQL error "Unable to connect to server 'XY': [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password." if we start Remote procedures stored in server 'XY'.

Procedures work only if they are launch with user DBA. Locale proxy procedures and remote procedures are owned by user DBA.

Remote tables works fine. Only procedures doesn't work.

In version 16 are big changes in system of privilegs. After upgrade other things work fine but remote procedures not.

Do you have any idea?