We have created Data warehouse server and planning to create Databases, Schema and users.
If i create any Database that will go under my name but i would like to create Any database under specific user so how can i do it?
Should i create sql server user/login or create AD login and create user under then create the Database so it will show as Database under that user not under my name?
What's the best practice?
I have to create also Schema for Data warehouse databases so any useful additional information will greatly helpful.