Sunday, June 7, 2020

How to create a backup user for ORACLE database

CREATE USER ORA_BKUP IDENTIFIED BY WHATEVER
QUOTA 1G ON  USERS;

grant sysbackup to ora_bkup;

SQL> grant create session to ora_bkup;

Grant succeeded.

SQL> grant DATAPUMP_EXP_FULL_DATABASE to ora_bkup;

Grant succeeded.

SQL> grant DATAPUMP_IMP_FULL_DATABASE to ora_bkup;

No comments:

Post a Comment