SQL Server Performance Forum – Threads Archive

How to create new database automatic for new user?

In the SqlServer 2000 database system, We use "Windows autmentiation" for the users to log in. Now we want to implement the following function: For every user in the domain WHO IS THE FIRST TIME LOG IN, we should 1. Create on new database (with the same name) for him.
2. Set the user’s default database to the new-created database.
3. Remove the user’s privilege to the other databases.
How should I set up the database system?

---

Sorry, but the question should not be HOW, but rather WHY, IMHO ???
–Frank
http://www.insidesql.de

---

I agree on this one. And, why would they have permissions to other databases if it’s their first time to login???????? Are you on Active Directory? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

---

]]>