Re: How to remove `guest' as Default Login ID in MSSQL2000?
From: Russell Fields (rlfields@sprynet.com)
Date: 11/20/02
- Next message: Steven Burns: "Re: Frustrated :("
- Previous message: Russell Fields: "Re: Execute sp issue"
- In reply to: Ann Yong He: "How to remove `guest' as Default Login ID in MSSQL2000?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Russell Fields" <rlfields@sprynet.com> Date: Wed, 20 Nov 2002 11:44:29 -0500
Ann,
"guest" is not a login but is a database user. The following is from the
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 ServerT but does not
have access to the database through his or her own user account.
* The database contains a guest user account.
--------
Therefore, you can drop the guest user from any database that you do not
want accessed in this way. Then the above condition would not allow anyone
to gain access to the database. (It is also possible to leave the guest
account and deny it all (or almost all) rights.)
Russell Fields
"Ann Yong He" <annyh79@hotmail.com> wrote in message
news:b42f01c29083$5a696f90$89f82ecf@TK2MSFTNGXA01...
> Hi, I would like to change the default login id from guest
> to another id (or null). Please advise on how I can do
> this, as this can't be done in Enterprise Manager (like
> version 6.x).
- Next message: Steven Burns: "Re: Frustrated :("
- Previous message: Russell Fields: "Re: Execute sp issue"
- In reply to: Ann Yong He: "How to remove `guest' as Default Login ID in MSSQL2000?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
