Login Confusion

Hi,

I am Just beginning to get to grips with SQL Server v 7 security on a stand
alone win 98 PC.

I have created a login which only has access to the pubs database and when I
try and connect to any other database (while using this login) I am
correctly told that I don't have access. However, Enterprise Manager does
not request a login and therefore the log in seems to grant full access to
every database.

How can I get Enterprise Manager to request a log in?

Thanks.Stevie D (Steve@.127.0.0.1) writes:
> I have created a login which only has access to the pubs database and
> when I try and connect to any other database (while using this login) I
> am correctly told that I don't have access. However, Enterprise Manager
> does not request a login and therefore the log in seems to grant full
> access to every database.
> How can I get Enterprise Manager to request a log in?

Right-click the server and select Edit Registration properties. There
is a checkbox for always being prompted.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland

This worked fine

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns960F305E4DBEYazorman@.127.0.0.1...
> Stevie D (Steve@.127.0.0.1) writes:
> > I have created a login which only has access to the pubs database and
> > when I try and connect to any other database (while using this login) I
> > am correctly told that I don't have access. However, Enterprise Manager
> > does not request a login and therefore the log in seems to grant full
> > access to every database.
> > How can I get Enterprise Manager to request a log in?
> Right-click the server and select Edit Registration properties. There
> is a checkbox for always being prompted.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp