Results 1 to 2 of 2

Thread: Guest account

  1. #1
    Join Date
    Nov 2003

    Unanswered: Guest account

    I want to know what is the guest account and what its use for ?

  2. #2
    Join Date
    Dec 2004
    York, PA


    Quote from BOL

    "The guest user account allows a login without a user account to access a database. A login assumes the identity of the guest user when both of the following conditions are met:

    The login has access to an instance of Microsoft® SQL Server™ but does not have access to the database through his or her own user account.

    The database contains a guest user account.
    Permissions can be applied to the guest user as if it were any other user account. The guest user can be deleted and added to all databases except master and tempdb, where it must always exist. By default, a guest user account does not exist in newly created databases.

    Avoid using the guest account; all logins without their own database permissions obtain the database permissions granted to this account. If you must use the guest account, grant minimum permissions. "

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts