Backing up a specific database

About this task

To grant a user privilege to back up a specific database, complete the following steps:

Procedure

  1. Run nzsql and connect to the database you want to allow the user to back up by entering: nzsql db1.
  2. Create a user user_backup with password password.
    For example: 
    DB1.SCHEMA(ADMIN)=> CREATE USER user_backup WITH PASSWORD 'password';
  3. Grant backup privilege to user_backup.
    For example: 
    DB1.SCHEMA(ADMIN)=> GRANT BACKUP TO user_backup;