DBS offers features such as full backup, incremental backup, and data restoration. The topic describes the database permissions and privileges that are required to perform database backup and restoration.

Account permissions

  • MySQL privileges
    Feature Required privilege
    Backup
    • Logical backup: SELECT, REPLICATION SLAVE, and REPLICATION CLIENT
    • Physical backup: LOCK_TABLES, REPLICATION_CLIENT, PROCESS, SUPER, CREATE, and RELOAD
    Restoration SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER
    Note
    • During incremental backups, DBS must 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 requires only the REPLICATION CLIENT privilege.
    • For ApsaraDB RDS databases, read only permissions are required to perform backups while read and write permissions are required to perform backup and restoration.
  • SQL Server privileges
    Feature Required privilege
    Backup SELECT, VIEW DEFINITION
    Restoration SELECT, INSERT, ALTER Database, REFERENCES, VIEW DEFINITION
  • Oracle privileges
    Feature Required privilege
    Backup DBA
    Restoration DBA
  • PostgreSQL privileges
    Feature Required privilege
    Backup SELECT or the SUPER role
    Restoration CREATE, INSERT, USAGE, REFERENCES, TRIGGER
  • MongoDB privileges
    Feature Required privilege
    Backup Read permissions on the admin databases, local databases, config databases, and databases to be backed up
    Restoration Read and write permissions on databases to be restored