显示标签为“developers”的博文。显示所有博文
显示标签为“developers”的博文。显示所有博文

2012年2月9日星期四

Basic security questions

Hi,

I am new to SQL 2005, can someone give me some details instructions about how to do below two tasks:

  1. 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”)
  2. 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