Backing up all databases

About this task

To grant a user privilege to back up all databases, complete the following steps.

Procedure

  1. Run nzsql and connect to the system database by entering: nzsql system
  2. Create a user user_backup with password password:
    For example, 
    SYSTEM.ADMIN(ADMIN)=> CREATE USER user_backup WITH PASSWORD 'password';
  3. Grant backup privilege to user_backup: 
    SYSTEM.ADMIN(ADMIN)=> GRANT BACKUP TO user_backup;