July 8, 2009 at 7:20 am
I hope someone can provide me with general information on this issue:
Every time a new database is created on our a server we have a certain user account (AD) that gets added to that database by default in addition to the usual suspects (information_schema, sys, dbo, guest). I've already removed the related SQL login entry for this AD account. Does anyone know how I can stop this from happening, or where default database users are specified? I've also noticed this same user has somehow been added to all the system DBs.
July 8, 2009 at 7:40 am
most likely this user has been added to the model database. As all new databases are created from the model database this user would get added to all databases that way.
If you don't require this anymore remove the user form model database.
---------------------------------------------------------------------
July 8, 2009 at 7:55 am
Ah, that's done the trick. Many thanks 🙂
I guess the trick now is to find out how it was added to the model DB since neither myself nor the other dba did this.
July 8, 2009 at 9:38 am
unless you have a profile trace (perhaps the default trace) from when it was done I do not know of a way to do that (would say it was impossible)
the createdate column in sysusers will tell you when the user was added to the database
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply