Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

grant EXP_FULL_DATABASE

malhiJul 24 2012 — edited Jul 24 2012
I have granted EXP_FULL_DATABASE to user ADEMPIERE, but when i check its rights, i found NO. What is the resolution.
SQL> grant EXP_FULL_DATABASE to ADEMPIERE;

Grant succeeded.

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

GRANTEE 		       GRANTED_ROLE		      ADM DEF
------------------------------ ------------------------------ --- ---
ADEMPIERE		       CONNECT			      NO  YES
ADEMPIERE		       EXP_FULL_DATABASE	      NO  NO
ADEMPIERE		       RESOURCE 		      NO  YES

SQL> 
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2012
Added on Jul 24 2012
7 comments
18,787 views