June 10, 2008 at 3:45 am
I have a user, connecting with their network account. They are developing their own db.
What is the norm - Giving that login db_owner role for that database, or aliasing that Login to dbo for that database?
June 10, 2008 at 7:16 am
Adding the logins into db_owner role is enough.
June 10, 2008 at 7:23 am
Agree, add the user to the role rather than aliasing.
June 10, 2008 at 7:25 am
And then as best practise when that dev creates their object they should specify dbo so that their user doesn't become the object owner?
June 11, 2008 at 11:41 am
Shark Energy (6/10/2008)
And then as best practise when that dev creates their object they should specify dbo so that their user doesn't become the object owner?
Yes, you got it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply