DBS offers features such as full backup, incremental backup, and data recovery. The section describes the database permissions and privileges that are required to perform database recovery.
|Backup||SELECT, REPLICATION SLAVE, REPLICATION CLIENT|
|Recovery||INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER|
- During incremental backups, DBS needs to execute the “show binary logs” statement. For MySQL 5.5.24 and earlier versions, this requires the SUPER privilege. For MySQL 5.5.25 and later versions, this only requires the REPLICATION CLIENT privilege.
- For RDS databases, read only permissions are required to perform backups, while read and write permissions are required to perform backup and recovery.