June 5, 2002 at 4:41 pm
Is there a way to make your server default to dbo owner when creating a table, etc. I have developers that create tables and then have to change ownership.
June 5, 2002 at 7:02 pm
Yes, use sp_addalias to alias their login to the built in dbo user.
Andy
June 7, 2002 at 7:41 am
I'll have to disagree that using app role is better - wouldnt you think that most development will take place in EM or QA?
Andy
June 7, 2002 at 7:58 pm
Also with an app role you won't be able to use profiler to see who is doing what or look in current activity. Even on a developement server you want to understand who is up to what.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply