Hi,
I am new to SQL 2005, can someone give me some details instructions about how to do below two tasks:
- All my developers are in a window domain user group, I need to grant dbo privileges to that domain group so then can do the their development work. The rule is all objects they create need to be owned by dbo not by there ID.( I can’t do it because I got “ The “Deafult_Schema clause cannot be used with a windows group”)
- Same as above but this time they only need select permission on tables nothing else.
Many thanks.
PC
See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=678115&SiteID=1 and the thread referenced there.
Thanks
Laurentiu
没有评论:
发表评论