New Login Question
From: Ron (anonymous_at_discussions.microsoft.com)
Date: 04/06/05
- Next message: Ron: "grant create_table permission?"
- Previous message: marcmc: "Re: Do the MVP's ever spend time here?"
- In reply to: Ron: "New Login Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 6 Apr 2005 09:32:16 -0700
Thanks all for your replies.
>-----Original Message-----
>Hello,
>
>I have been programming with Sql Server 2000 for 2-3
years
>now. But I am just now starting out with having to also
>be the DBA of Sql Server 2000. My question is about
>creating new Logins.
>
>I noticed that at the bottom of the New login dialog
there
>are 2 dropdown boxes. One selects a database to log in
to
>and the other is the language. The database login
>dropdown always has master listed. If I leave that alone
>and then go to the Database access tab where I select
what
>database the new login can access I leave master in that
>dialog unchecked but I check some other database. If a
>user creates a connection with a tool like MS Access 2002
>adp, the user can connect to master but can't access
>anything because I did not check master in the Database
>access tab of the New Login dialog. So my question is -
>what is the significance of the database dropdown on the
>first dialog of the Login dialog? If I change the
>database dropdown from Master to just the desired
>database, then the user cannot connect to master in
>addition to not being able to access any objects in
>master. But does master contain login information? If
>the user is only going to be creating ODBC connections to
>the desired Sql DB, does the user need to be able to
>connect to master?
>
>Thanks,
>Ron
>.
>
- Next message: Ron: "grant create_table permission?"
- Previous message: marcmc: "Re: Do the MVP's ever spend time here?"
- In reply to: Ron: "New Login Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
