Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I create database in SQL server Management Studio, user with name "admin" is also created for all databases:

enter image description here

Why this user is created? And how I can change this behavior?

share|improve this question
1  
Looks like I have found the reason, this user exists in System Databases=> Model. That is why it was created for all new databases. –  Maslov Anton Mar 12 '13 at 4:44
6  
Add your own comment as a response so the question doesn't linger 'unanswered' –  Remus Rusanu Mar 12 '13 at 8:45
add comment

1 Answer

Looks like I have found the reason, this user exists in System Databases=> Model. That is why it was created for all new databases.

share|improve this answer
    
I was going to say that it was probably in the Model database. Good job figuring it out. –  DForck42 Mar 13 '13 at 14:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.