Restoring a specific database

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 a specific database, complete the following steps.

Procedure

  1. Run nzsql and connect to the database you want to allow the user to restore by entering: nzsql db1
  2. Create the user_restore user with the password password. 
    DB1.SCHEMA(ADMIN)=> CREATE USER user_restore WITH PASSWORD 'password';
  3. Grant restore privilege to user_restore. 
    DB1.SCHEMA(ADMIN)=> GRANT RESTORE TO user_restore;

    If the database does not exist, you must first create an empty database and then assign the Restore privilege to the user. You must assign the Restore privilege on an empty database.