May 30, 2014 at 4:41 am
Hi All,
Need your help on following.
Today I received requirement from one of my user,
He want access to his login to create new database and when ever he create the new database he want that login to be dbowner of that new database.
May 30, 2014 at 5:43 am
He can fire the create database command to create the database. See http://msdn.microsoft.com/en-us/library/ms176061%28v=sql.100%29.aspx.
Once he creates the database, he can create users by using the create user command. See http://msdn.microsoft.com/en-us/library/ms173463%28v=sql.100%29.aspx.
The user that creates the database is the owner of that database unless it's changed with sp_changedbowner.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply