|
Home > Archive > MS SQL Server > October 2006 > How to access multiple databases in SQL2005 with an SQL Login
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 |
How to access multiple databases in SQL2005 with an SQL Login
|
|
| Chris Wood 2006-10-24, 6:28 pm |
| Hi,
Our systems make use of the 'guest' id to access other application databases
in SQL2000, without using cross database chaining. We are using SQL Logins.
Now in SQL2005 this is proving to be much more difficult. I have enabled the
'guest' id in the second database (grant connect to guest ;) and given the
'guest' user Select permission on the dbo schema. I have also given the
'guest' user Select permission on the specific user table in the dbo schema.
This still gives me a permission error on the database table in the second
database.
What else do I need to do?
Thanks
Chris
| |
| Chris Wood 2006-10-24, 6:29 pm |
| I have the answer.
I had to give the role 'public' Select permission on the dbo schema of the
database.
Chris
"Chris Wood" < anonymous@discussion
s.microsoft.com> wrote in message
news:%23u9cWIz2GHA.5056@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> Our systems make use of the 'guest' id to access other application
> databases in SQL2000, without using cross database chaining. We are using
> SQL Logins.
>
> Now in SQL2005 this is proving to be much more difficult. I have enabled
> the 'guest' id in the second database (grant connect to guest ;) and given
> the 'guest' user Select permission on the dbo schema. I have also given
> the 'guest' user Select permission on the specific user table in the dbo
> schema. This still gives me a permission error on the database table in
> the second database.
>
> What else do I need to do?
>
> Thanks
>
> Chris
>
|
|
|
|
|