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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy