pat98's always & forever

You created a user (USR001) and granted the roles EXP_FULL_DATABASE and IMP_FULL_DATABASE. This user is needed to perform full database exports/imports. When a full database export is started, this ends with error:

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

A full database import ends with errors:

IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

You verified the privileges and the granted roles are there:

SQL> select * from dba_sys_privs where grantee = 'USR001';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
USR001                         CREATE SESSION                           NO

SQL> select * from dba_role_privs where grantee = 'USR001';

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
USR001                         EXP_FULL_DATABASE              NO  NO
USR001                         IMP_FULL_DATABASE              NO  NOCause
The granted roles are not activated (DEFAULT_ROLE is NO).
Solution
First activate the roles with:

SQL> alter user usr001 default role all;

Then verify with:

SQL> select * from dba_role_privs where grantee = 'USR001';

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
USR001                         EXP_FULL_DATABASE              NO  YES
USR001                         IMP_FULL_DATABASE              NO  YES
and re-start export/import, the roles are now activated (DEFAULT_ROLE is YES).