Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-06-22 : 04:23:37
|
| Hi allwhat is the use of Guest account...Thanks in advance.. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-06-22 : 05:00:04
|
| Every database includes a guest user by default. The guest user's permissions are inherited by users that don't have a user account in the database.Mark |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-22 : 05:13:13
|
| which means, that if you have a login to the server but have not been granted database access (including permissions), your login will have the same permission set as the guest account in that databaseit's used for cross database queries especially when using application rolesit's a security risk, so if you plan in activating this account, make sure you have locked down the server, i only implement this if the server is dedicated, like a reporting server--------------------keeping it simple... |
|
|
|
|
|
|
Use of guest account