Re: remote access SQL

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 03/03/05


Date: Thu, 3 Mar 2005 05:31:01 -0800

Hi

Yes, public has only read access.

Regards

"Nick" wrote:

> HI mike:
> so does it only have read right to those database, like master, model.
>
> do not have write right.
>
> Cheers
>
> nick
>
>
>
>
> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
> news:O4Ys1J4HFHA.2740@TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > Not with SQL Server 2000. Public has rights to read certain tables in
> master
> > that enables the listing of databases.
> >
> > Regards
> > --------------------------------
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Nick" <fsheng@ebreathe.co.nz> wrote in message
> > news:OGi1Q#3HFHA.588@TK2MSFTNGP15.phx.gbl...
> > > HI All:
> > >
> > > I want to create a sql account that only allow to operate one
> > database.
> > >
> > > i create a acount call derek , then only select one acess database
> > ,name
> > > is A. with readonly property.
> > >
> > >
> > > but when i use another computer to connect my sql server using derek
> > > account, it will still showing some other database like master , model.
> > > etc.
> > >
> > > what i want that is only show database A. no more else.
> > >
> > > is that possible to do that?
> > >
> > > Cheer
> > >
> > > nick
> > >
> > >
> >
> >
>
>
>