Post reply

Who would like to explain the uses of account guest in SQL SERVER?

  • June 11, 2009 at 11:57 pm

    #205945

    Who would like to explain the uses of account guest in SQL SERVER?

    Thanks

  • June 12, 2009 at 1:37 am

    #1008423

    Ok, I give it a try.

    the guest account is used to give access to a database without explicitely creating a databaseuser for a login. The best example is the mastter database. Most SQL logins are not created as a user in master. But for login and certain other actions the login must access sytem tables and procedures in master. Because the guest user is enabled in master, every login even though it is not an explicit usere in master, can access these system tables. The guest user has the permissions of the public role.

    By default the guest user is enabled only in master, msdb and tempdb. In model and all user databases the guest user is disabled.

    see also:

    http://www.mssqltips.com/tip.asp?tip=1172

    [font="Verdana"]Markus Bohse[/font]

  • June 15, 2009 at 12:34 am

    #1009488

    Thanks !

  • June 15, 2009 at 12:48 am

    #1009490

    MarkusB (6/12/2009)

    The guest user has the permissions of the public role.

    [/url]

    Just a small clarification. Every user and role (including the user guest) will get the permissions that are specified for the public role. You can also grant specific permissions directly to the user guest.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply