All Products
Search
Document Center

Required database privileges

Last Updated: Dec 07, 2018

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.

MySQL privileges

Feature Required privilege
Backup SELECT, REPLICATION SLAVE, REPLICATION CLIENT
Recovery INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER
  1. 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.
  1. For RDS databases, read only permissions are required to perform backups, while read and write permissions are required to perform backup and recovery.