|
Home > Archive > SQL Anywhere database > June 2005 > Remote-Server - and the user-access to remote-tables/procedures.....
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 |
Remote-Server - and the user-access to remote-tables/procedures.....
|
|
| M.Erlinger 2005-06-12, 3:23 am |
| Hello
ASA 9.02 - Build 3124
i have following problem with remote-servers:
in my first db i have stored all users, that are in the application work's -
all these users are in the group "AppUser"; now i have add a external login
for the group "appUser" to the remote-server. if i select with the
appUser-Login, i can access the tables and procedures from the
remote-server - BUT if i connect with a normal user from the group
"AppUser" ---> i cant' access any object.
is it possible to create for every user in the first DB - an external login
to the remote-server???
or is there any way to create an "group-external-login"??
many thank's in advance for help
Michael
| |
| Stephen Rice 2005-06-13, 11:23 am |
| M.Erlinger wrote:
> Hello
> ASA 9.02 - Build 3124
>
> i have following problem with remote-servers:
> in my first db i have stored all users, that are in the application work's -
> all these users are in the group "AppUser"; now i have add a external login
> for the group "appUser" to the remote-server. if i select with the
> appUser-Login, i can access the tables and procedures from the
> remote-server - BUT if i connect with a normal user from the group
> "AppUser" ---> i cant' access any object.
>
> is it possible to create for every user in the first DB - an external login
> to the remote-server???
> or is there any way to create an "group-external-login"??
>
> many thank's in advance for help
> Michael
>
>
AFAIK there is no group external login
/steve
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
--- Please Post ---
Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
"Report a bug" are all available on www.ianywhere.com
| |
| M.Erlinger 2005-06-13, 1:23 pm |
| maybe - is there any trick to bypass this problem - and must don't for every
user create an external login......???
thank's
Michael
"Stephen Rice" <NSsrice@ianywhere.com> schrieb im Newsbeitrag
news:42ada104$1@foru
ms-2-dub...
> M.Erlinger wrote:
> AFAIK there is no group external login
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> --- Please Post ---
> Whitepapers, Tech Docs, Solved Cases, Bug Fixes and
> "Report a bug" are all available on www.ianywhere.com
| |
| Breck Carter [TeamSybase] 2005-06-13, 1:23 pm |
| Have you tried putting everything inside procedures owned by appUser?
I'm not 100% sure that will work, but statements inside procedures run
with the permissions of the owner, not the current user.
Breck
On 13 Jun 2005 11:11:16 -0700, "M.Erlinger"
<michael.erlinger@vienna.at> wrote:
>maybe - is there any trick to bypass this problem - and must don't for every
>user create an external login......???
>thank's
>Michael
>
>"Stephen Rice" <NSsrice@ianywhere.com> schrieb im Newsbeitrag
> news:42ada104$1@foru
ms-2-dub...
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|