Database backup and restore permissions

Nitesh

I want to create a role which has permissions only to take database backup and restore it.How can i do it?

matttrax

Permissions

System 5410 -- Tools, Backup
System 5420 -- Tools, Restore

DaveT

Hi

:shock: If you allow someone take a backup then by definition they can see all the data if they restore the backup off-line :shock:

IMHO Backup and restore is an administration role who should have full access anyway

jlmorris3

nevermind

kine

No, if you need to make backup, you need to be SUPER (or you need to have SELECT permissions to all tables - e.g. by adding this permission on DataTable 0). Else you will end with role with permissions for all tables.