RE: just below sysadmin

From: Stephen Strong (anonymous_at_discussions.microsoft.com)
Date: 04/02/04


Date: Thu, 1 Apr 2004 15:41:03 -0800

Most replication admin tasks require sysadmins membership :-( However, backup, logins and db permissions can be managed via builtin roles like db_backupoperator (on per db basis), securityadmin (per SQL Instance) or db_securityadmin and db_accessadmin (per db). You may also add these people to the db_denydatareader and db_denydatawriter roles (per db).