Re: Sql users are redirected to wrong databases
From: oj (nospam_ojngo_at_home.com)
Date: 12/20/04
- Previous message: Murtix Van Basten: "Sql users are redirected to wrong databases"
- In reply to: Murtix Van Basten: "Sql users are redirected to wrong databases"
- Next in thread: AnthonyThomas: "Re: Sql users are redirected to wrong databases"
- Reply: AnthonyThomas: "Re: Sql users are redirected to wrong databases"
- Reply: Kevin McDonnell [MSFT]: "Re: Sql users are redirected to wrong databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 19 Dec 2004 19:06:40 -0800
Take a look at sp_defaultdb in book online. This allows to explicitly set a
login to a specific database.
Also, try to explicitly define the database context in the connection string.
e.g.
database=casts;
"Murtix Van Basten" <murtix@murtix.com> wrote in message
news:41c63cee_3@alt.athenanews.com...
> Hi,
>
> I am not sure if this would be the right heading for the question but,
> this is something I haven't faced before.
>
> In a mssql 2000 sp3 server has around 30 users and 30 databases. Each user
> is a dbowner of an individual database. There is not any user owns two or
> more database in the server.
>
> Recently, the users are complaining about, when they are try to access to
> the server via ent-manager or via a connection string, the server is making
> them try to connect to a database that is not they are supposed to connect
> to. For example:
>
> username: database:
> ----------------------------------
> garfield ------------> cats
> lessie --------------> dogs
>
> This is the way it supposed to be. But when garfield wants to manage his
> "cats" database, he ends up connecting to the "dogs" database, even though
> he specifies that he wants to connect to the "cats" database. Naturally, he
> gets a permission error when he connects to the "dogs" database, becase
> garfield doesnt have any permit on the "dogs" database.
>
> I dont know how did it happen. I have checked the databases and users at the
> server, all are look fine and the settings are correct. I could not see any
> problems on the sql server logs. I dont know if it is a security problem or
> something screwed up in the database server. If anyone has any idea about
> this issue, please share with me.
>
> Thanks.
>
> Murtix.
>
>
- Previous message: Murtix Van Basten: "Sql users are redirected to wrong databases"
- In reply to: Murtix Van Basten: "Sql users are redirected to wrong databases"
- Next in thread: AnthonyThomas: "Re: Sql users are redirected to wrong databases"
- Reply: AnthonyThomas: "Re: Sql users are redirected to wrong databases"
- Reply: Kevin McDonnell [MSFT]: "Re: Sql users are redirected to wrong databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
