Database Administration (MOSC)

MOSC Banner

Privileges that needs a user to do full expdp in version 12c

edited Dec 1, 2014 6:12AM in Database Administration (MOSC) 6 commentsAnswered

Hi experts.

What are the privileges that needs a user to do full expdp in version 12.1.0.2?

Please tell me if I need to add something or this is still the correct way:

create user backup_user identified by <erased> default tablespace tools temporary tablespace temp;

grant connect, exp_full_database, imp_full_database, select_catalog_role, unlimited tablespace, select any sequence, become user, backup any table, analyze any to backup_user;

grant select on sys.incexp to backup_user;

grant select on sys.incfil to backup_user;

grant select on sys.incvid to backup_user;           

Grant exempt access policy to backup_user;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center