January 9, 2009 at 8:14 pm
Hi experts,
I'm looking for a way to automatically add a group on one of our SQL 2005 servers to the db_owner role for any and every database that is created. I don't want them to have sysadmin or anything like that just db_owner. They can have this role on any database and preferably I wouldn't have to perform the addition ever it would automatically add this particular group or user (yet to be determined) to that role on every new DB creation.
Thanks in advance,
January 10, 2009 at 2:15 pm
Add it to to the [model] database. then when you create a new database, it will copy the properties from [model] to your new database, including the Users and their database_role mappings.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply