backup operator

I have to assign a group db_backupoperater permissions. Do they need any other role like db_dbwriter or dbreader? I don't usually assign roles like this.

Thanks

Hello,

This of course will depend upon what permissions you want the group to have. If you only want the group to be able to issue backup commands against the database in question, then db_backupoperater is all that is needed.

Cheers
Rob

Backup job permissions...

What roles/permissions can you give a login in SQL Server
to allow him/her to see the Database Maintenance Wizard
and Backup Jobs in order to check the status?
Thanks,
ThomasHi Thomas,
According to my experience, if the login account that is used to open
Enterprise Manager is not a member of sysadmin server role, he/she cannot
see the following icons under the Management folder.
-Current Activity
-Database Maintenance Plans
-SQL Server Logs
So you may give the login sysadmin permission.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
William Wang
Microsoft Partner Online Support
| Content-Class: urn:content-classes:message
| From: "Thomas.LeBlanc" <Thomas.LeBlanc@.NoSpam.Com>
| Sender: "Thomas.LeBlanc" <Thomas.LeBlanc@.NoSpam.Com>
| Subject: Backup job permissions...
| Date: Tue, 29 Jul 2003 14:02:50 -0700
| Lines: 6
| Message-ID: <034101c35614$c51813d0$a501280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNWFMUYCEK3zv1OTuiKQYXOp8kbIQ==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:298439
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| What roles/permissions can you give a login in SQL Server
| to allow him/her to see the Database Maintenance Wizard
| and Backup Jobs in order to check the status?
|
| Thanks,
| Thomas
||||There is a builtin backup_admin role, this may have some
of what you are looking for.
"Thomas.LeBlanc" <Thomas.LeBlanc@.NoSpam.Com> wrote in message
news:034101c35614$c51813d0$a501280a@.phx.gbl...
> What roles/permissions can you give a login in SQL Server
> to allow him/her to see the Database Maintenance Wizard
> and Backup Jobs in order to check the status?
> Thanks,
> Thomas