|
Home > Archive > SQL Anywhere database > August 2005 > Can a User Group have an External Login to a Remote ASA9
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can a User Group have an External Login to a Remote ASA9
|
|
| Geoff Sutcliffe 2005-08-24, 3:23 am |
| ASA 9.0.2.3004 Running as a network server on a W2k Server.
The server hosts 2 databases. (DataBase1 & DataBase2)
Our application is connected to DataBase1 but has functionality which
requires it to update a table in DataBase2.
We established a Remote Server in DataBase1 to connect to DataBase2.
We created a proxy table in DataBase1 which references the table in
DataBase2.
We created a User in DataBase2 which has update permissions on the table.
(LOGIN2)
We created a User in DataBase1 which has a remote login using LOGIN2.
This setup works correctly, but means that every user must have an external
login setup.
We thought maybe we could assign the external login to a group instead of
the user and give the users membership in the group but although ASA lets
you set this up, it doesnt work.
We get the error "Unable to connect to server <servername> Invalid user ID
or password"
Is this a limitation or have I missed something.
TIA
| |
| Bruce Hay 2005-08-24, 9:23 am |
| ASA does not try to use group memberships to find an external login for a
remote database.
You might try performing the update via a stored procedure, where the
procedure owner has an associated external login to the remote database.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Geoff Sutcliffe" <geoff@datagaard.com.au> wrote in message
news:430c01aa$1@foru
ms-2-dub...
> ASA 9.0.2.3004 Running as a network server on a W2k Server.
>
> The server hosts 2 databases. (DataBase1 & DataBase2)
> Our application is connected to DataBase1 but has functionality which
> requires it to update a table in DataBase2.
>
> We established a Remote Server in DataBase1 to connect to DataBase2.
> We created a proxy table in DataBase1 which references the table in
> DataBase2.
> We created a User in DataBase2 which has update permissions on the table.
> (LOGIN2)
> We created a User in DataBase1 which has a remote login using LOGIN2.
>
> This setup works correctly, but means that every user must have an
external
> login setup.
>
> We thought maybe we could assign the external login to a group instead of
> the user and give the users membership in the group but although ASA lets
> you set this up, it doesnt work.
>
> We get the error "Unable to connect to server <servername> Invalid user ID
> or password"
>
> Is this a limitation or have I missed something.
>
> TIA
>
>
| |
| Geoff Sutcliffe 2005-08-24, 8:24 pm |
| Thanks Bruce, stored procedure looks like the answer.
"Bruce Hay" < h_a_y@i~a~n~y~w~h~e~
r~e.c_o_m> wrote in message
news:430c7368$1@foru
ms-1-dub...
> ASA does not try to use group memberships to find an external login for a
> remote database.
>
> You might try performing the update via a stored procedure, where the
> procedure owner has an associated external login to the remote database.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
> "Geoff Sutcliffe" <geoff@datagaard.com.au> wrote in message
> news:430c01aa$1@foru
ms-2-dub...
table.[color=darkred]
> external
of[color=darkred]
lets[color=darkred]
ID[color=darkred]
>
>
|
|
|
|
|