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 |
|
koln5
Starting Member
29 Posts |
 Posted - 2002-12-27 : 17:55:37
|
| Could someone please tell me some of the ramifications I might face if I delete the guest account on all the databases ?thanks in advance |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-28 : 00:23:50
|
quote:
Could someone please tell me some of the ramifications I might face if I delete the guest account on all the databases ?thanks in advance
From BOL:A login ID by itself does not give a user permissions to access objects in any databases. A login ID must be associated with a user ID in each database before anyone connecting with that login ID can access objects in the databases. If a login ID has not been explicitly associated with any user ID in a database, it is associated with the guest user ID. If a database has no guest user account, a login cannot access the database unless it has been associated with a valid user account.Expect the UnExpected |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-30 : 06:57:57
|
| Just to add, you cannot remove the guest account from master or tempdb. HTHJasper Smith |
|
|
|
|
|
|
Guest account