Welcome to TechNet Blogs Sign in | Join | Help

Useful information about Guest Account in SQL Server

guest user

When a database is created, the database includes a guest user by default. Permissions granted to the guest user are inherited by users that do not have a user account in the database.

The guest user cannot be dropped, but it can be disabled by revoking its CONNECT permission. The CONNECT permission can be revoked by executing REVOKE CONNECT FROM GUEST within any database other than master or tempdb.

 

 

http://msdn2.microsoft.com/en-us/library/aa905195(SQL.80).aspx

 

http://msdn2.microsoft.com/en-us/library/ms190928.aspx

Published Wednesday, August 15, 2007 4:26 PM by vishah

Comments

Anonymous comments are disabled
 
Page view tracker