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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2007-01-10 : 16:18:37
|
| Can a database owner (not the db_owner role) ever be an Active Directory group instead of a user? |
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-01-10 : 17:21:44
|
| A database owner can be a windows or SQL user, but I don't believe it's possible to use an Active Directory group. As an FYI I tried to update the dbowner in pubs to a group and was unsuccessful. Just kept getting the message "The login Group does not exist" |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2007-01-10 : 17:28:25
|
| Thanks, that's what I suspected. Just to verify, did you try to update the db owner in pubs after the group in question was set up as a login? |
|
|
|
propanecan
Yak Posting Veteran
60 Posts |
Posted - 2007-01-10 : 17:45:00
|
| Yes, that is correct. |
|
|
|
|
|
|
can db owner be a group?