I am trying to get the security items fixed to be correct, so I only want to give least permissions.
I want all of the databases to have the owner set to sa instead of the user.
I gave the developer dbcreator.
When they go to create the database it gives them an error, but it actually creates the database with their user as the owner.
The error is: Set owner failed for Database 'namehere'
Cannot Find the principal 'sa', because it does not exist or you do not have permission. Error 15151.
What's the best way to accomplish this doing it the right way?