Restoring all databases

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

About this task

To allow a user to restore all databases, complete the following steps.

Procedure

  1. Run nzsql and connect to the system database by entering: nzsql system;
  2. Create the user_restoreuser with the password password. 
    SYSTEM.ADMIN(ADMIN)=> CREATE USER user_restore WITH PASSWORD 'password';
  3. Grant restore privilege to user_restore. 
    SYSTEM.ADMIN(ADMIN)=> GRANT RESTORE TO user_restore;