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 |
|
dwalker79
Yak Posting Veteran
54 Posts |
 Posted - 2008-07-16 : 13:06:52
|
| Has anyone ever experienced an issue where logins somehow change their default database to one that they don't actually have access to. I've seen this happen to many different SQL Server logins in our environment. I can't figure out how the login's default database is reseting itself automatically somehow?Have anyone run across this before?Please help!Thanks!!Dustin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-07-16 : 15:32:51
|
| No, there was no restore done. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 19:49:46
|
| Do they have rights to change? |
|
|
|
dwalker79
Yak Posting Veteran
54 Posts |
Posted - 2008-07-16 : 19:56:20
|
| No they do not. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 22:29:44
|
| It'll happen if login's default db dropped. |
|
|
|
|
|
|
Login's Default DB Changed