Be Alpha
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment