Re: SQL Default Login?
From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 11/14/02
- Next message: Richard Waymire [MS]: "Re: Cumulative Patches (for SQL Server)"
- Previous message: Sue Hoegemeier: "Re: Permissions for login?"
- In reply to: Audrey Lim: "SQL Default Login?"
- Next in thread: Audrey Lim: "Re: SQL Default Login?"
- Reply: Audrey Lim: "Re: SQL Default Login?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dan Guzman" <danguzman@nospam-earthlink.net> Date: Wed, 13 Nov 2002 20:46:42 -0600
The guest database user provides logins with a security context when
they haven't been explicitly granted database access. This is needed
for master and tempdb so that you don't need to grant every login access
to these shared databases.
You can ignore the default login reported by xp_loginconfig. This is
not related to the guest database user and is provided only for
backwards compatibility.
-- 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 ----------------------- "Audrey Lim" <robwhitz@yahoo.com> wrote in message news:f90801c28b6b$4331e4a0$37ef2ecf@TKMSFTNGXA13... > I executed the stored procedure 'xp_loginconfig' in the > Master Database. It shows that the default login for the > database is guest user. I understand that the guest user > can be deleted and added to all databases except master > and tempdb, where it must always exist. > > A few questions:- > - What is the main purpose of guest in both master and > tempdb? > - Can I change the default login to another account in > both master database without revoking the guest user? > > I would appreciate any advise on the above questions. > > Thanks, > Audrey >
- Next message: Richard Waymire [MS]: "Re: Cumulative Patches (for SQL Server)"
- Previous message: Sue Hoegemeier: "Re: Permissions for login?"
- In reply to: Audrey Lim: "SQL Default Login?"
- Next in thread: Audrey Lim: "Re: SQL Default Login?"
- Reply: Audrey Lim: "Re: SQL Default Login?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
