Privilegs of remote procedures after upgrade

[Former Member]

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?

Thanks!

Petr

[VolkerBarth]

You may have a look at the "extern_login_credentials" option introduced in v16, cf. the docs: DocCommentXchange.

That topic (and the change in behaviour compared to v12 and beolw) has also been discussed in lenth in the SQL Anywhere Forum here:

http://sqlanywhere-forum.sap.com/questions/15831.

[former_member194571]

Petr,

This looks precisely like a lack of externlogin mappings.

HTH

Volker