Re: user's rights

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/15/03 

Date: Tue, 15 Jul 2003 08:31:12 -0500

You can remove guest from the pubs and Northwind databases to prevent
them from being accessed. The guest user is required in the master and
tempdb system databases since these are needed for users to use SQL
Server. Guest and public permissions in those databases are quite
limited. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Usman" <jathol@hotmail.com> wrote in message
news:%23b3EnKpSDHA.2276@TK2MSFTNGP10.phx.gbl...
> hi ...
> I have a database "mydatabase"  and I create a user "mydayauser"
> on the create user screen .. on access data.. I select that data and
choose
> .. first 2 options
>
> publinc
> db_owner
>
> I want this user to access only this database...
> but when this user creates DSN ,,,  he can see all the default
databases..
> like.. master, pub ets..
> how can disable such databases for this user
>
> thanks
> Uman
>
>

Relevant Pages

  • Bay Breeze Software Released SQL Edge 1.2
    ... Bay Breeze Software Released SQL Edge 1.2. ... Tree View displays master table records as top-level tree nodes. ... Support any JDBC compatible databases. ...
    (comp.lang.java.databases)
  • Re: How can I remove Public access to SQL Express dbs?
    ... Guest has no CONNECT permission in user databases by default. ... You can't delete guest but can render it unusable by revoking CONNECT permission in databases other than master and tempdb. ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)
  • Re: master and msdb database permissions
    ... master and msdb through the guest account. ... objects in those databases. ... permissions come from - whatever permissions have been ...
    (microsoft.public.sqlserver.security)
  • Re: How to downgrade from Enterprise to Standard?
    ... It depends on how much you have in your master, Model and MSDB databases. ... > the new ones with te old ones work, or do I need to start the new SQL ... >> uninstall and install sql standard edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: How can I remove Public access to SQL Express dbs?
    ... You can't delete guest but can render it unusable by revoking ... CONNECT permission in databases other than master and tempdb. ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)