Help with User Roles

[AnnaWnz]

Hi

I am running a script that includes ALTER DATABASE, which requires a user with one of the following roles:
- sysadmin
- dbcreator
- db_owner

We don't want to use sa to run the script, but use someone's usual login.

Is there any issue with having more than one db_owner for a database. Or is it better to give the user sysdamin? Is there a good reference somewhere that identifies what sorts of things users with one of the above roles can perform, that a standard user can't.

Cheers

Anna

 

[billchris]

Adding multiple users to a role is actually a good idea.

Look here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_3xns.asp

“I have always found that plans are useless, but planning is indispensable.” --Dwight Eisenhower