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 operator

I need to give a group the role of db_backup operator. do they need anything else like db_datareader or writer? I'm not sure what they will be able to do other than backup? I've never given anyone this role.
ThanksThis is SQL forum (language, not database). Your question seems to be database-dependant, so you'd perhaps better ask it in forum which covers the database you use (is it MS SQL Server, DB2, ...?).