For backup and restore operations, the following table shows the
privilege names used at the SQL level in the
REVOKE statements, along with the
column name associated with each privilege in the grant tables and
the context in which the privilege applies.
RESTORE privilege enables
the use of
RESTORE to restore
databases. Server administrators should be careful which users
are granted the
privilege because restore operations are destructive and
replace existing data.
You might also need additional privileges to perform backup and restore operations, but which privileges these will be is currently under discussion.