My Oracle Support Banner

What are the EXPORT/IMPORT FULL DATABASE System Priviliges? (Doc ID 737614.1)

Last updated on JULY 25, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Goal

You try to perform a full database export/import. For this reason, you granted the system privileges EXPORT(IMPORT) FULL DATABASE to the user but the export/import fail with error message, like demonstrated in the following example:

connect / as sysdba
drop user test_exp cascade;

create user test_exp identified by <PASSWORD> default tablespace users temporary tablespace temp;
grant connect, resource, export full database to test_exp;

select * from dba_sys_privs where grantee = 'TEST_EXP';

 

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
TEST_EXP                       EXPORT FULL DATABASE                     NO
TEST_EXP                       UNLIMITED TABLESPACE                     NO

 

select * from dba_role_privs where grantee = 'TEST_EXP';

 

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
TEST_EXP                       CONNECT                        NO  YES
TEST_EXP                       RESOURCE                       NO  YES


Then, original export:

#>  exp test_exp/<PASSWORD> file=test-exp.dmp full=y log=test_exp.log


stops with:

EXP-00023: must be a DBA to do Full Database or Tablespace export


In similar way, DataPump export:

#> expdp test_exp/<PASSWORD> directory=dpu dumpfile=test_exp.dmp full=y logfile=test_exp.log


stops with:

ORA-31631: privileges are required
ORA-39161: Full database jobs require privileges

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.