Re: Guest userin Master and tempdb database

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 04/16/05

  • Next message: Joseph Bittman MCAD: "Re: Guest userin Master and tempdb database" 
    Date: Sat, 16 Apr 2005 11:20:29 -0500

    Hi,,

    By default, the guest login doesn't exist in newly created databases, but
    you can add it or delete it from all databases except master and tempdb.
    Most users access master and tempdb as guests and because of this, you can't
    remove the guest account from these databases. Don't worry-a guest has
    limited permissions and privileges in master and tempdb.

    There is a MS article mentioning this:-

    http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c05ppcsq.mspx

    See the topic Working with the Guest Login

    Thanks
    Hari
    SQL Server MVP

    "Dennis" <Dennis@discussions.microsoft.com> wrote in message
    news:A1CFD02E-EAF1-4215-8BD6-A106B5B9639B@microsoft.com...
    > Hi,
    >
    > Is it OK for me to delete the Guest user in Master and tempdb database? Is
    > there any problems will be caused?
    >
    > Thanks
    >
    > Dennis.

  • Next message: Joseph Bittman MCAD: "Re: Guest userin Master and tempdb database"

    Relevant Pages

    • Re: select from one db only
      ... Those databases are available to anyone who can login to the server because ... You should never remove guest from master ...
      (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)
    • backup after installation
      ... and the application databases? ...
      (microsoft.public.sqlserver.programming)
    • Re: users rights
      ... You can remove guest from the pubs and Northwind databases to prevent ... SQL Server MVP ... master, pub ets.. ...
      (microsoft.public.sqlserver.security)
    • MSDE newbie question: contents of default databases
      ... How do I get a list of the tables that are in these databases? ...
      (microsoft.public.sqlserver.msde)