Results 1 to 2 of 2

Thread: guest user

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: guest user

    Hi All,


    (1) How can we add more than 1 "guest" user to a single db ?
    (2) If I delete "guest" from master i get an error Number 17544
    You cannot drop the 'guest' user from master or tempdb
    What if I dont want guest user in master
    (3) Can i add 2 guest users with different name specifying same login ?

    thx

  2. #2
    Join Date
    Sep 2003
    Posts
    17
    Hi,

    You can't drop the guest user from master and tempdb.
    In master it is used when someone logs in and has no access to it's default db, then it's put into the master (because of the guest user).

    You can have many users assigned to the same login, but in different databases, not in the same.

    Regards,
    Ulrike

Posting Permissions

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