New Login Question

From: Ron (anonymous_at_discussions.microsoft.com)
Date: 04/06/05 

Date: Wed, 6 Apr 2005 08:09:40 -0700

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

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)