Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-04 : 08:02:59
|
| Carlos writes "I am trying to implement Windows Authentication; for that purpose I created a login using a Windows group, assigned it process administrators and database creators server roles. I also assigned it db_owner database role. Here is the problem, when connecting to the SQL server using Windows Authentication and creating a new object (a table, sp) the owner of this new object is the person that created the object, not dbo. This causes issues when somebody else tries to use those new objects. How can these new objects be owned by dbo? Any ideas?Carlos" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-04 : 11:30:59
|
create the table and specify the owner name like this:create table dbo.tablename ... -ec |
 |
|
|
|
|
|
Windows Authentication with EM