Home » RDBMS Server » Server Utilities » ORA-31685 and ORA-01932 (Oracle 10.2.0.2)
ORA-31685 and ORA-01932 [message #493257] Mon, 07 February 2011 02:47 Go to next message
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
Senior Member
Hi,

I'm trying to deploy the schema using DATAPUMP API. The user from which the schema get deployed has the direct privilege of CREATE USER (not through role). But got the insufficient privileges error.
Processing object type SCHEMA_EXPORT/USER
ORA-31685: Object type USER:"SCOTT1" failed due to insufficient privileges. Failing sql is:
 CREATE USER "SCOTT1" IDENTIFIED BY VALUES '4EBB0DDE3C79FE47' DEFAULT TABLESPACE "USERS" 
TEMPORARY TABLESPACE "TEMP2" PROFILE "APP_PROFILE"

But the user get created successfully when run the CREATE statement manually.

Could anyone tell me which privilege is missing?

One more is..
I have created the user manually and again run the deployment procedure. Got the below error for ROLE_GRANTS.

Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01932: ADMIN option not granted for role 'EXP_FULL_DATABASE'
Failing sql is:
 GRANT "EXP_FULL_DATABASE" TO "SCOTT1"


The user has EXP_FULL_DATABASE with ADMIN Option and IMP_FULL_DATABASE with ADMIN option direct privileges.

Please tell me where i'm wrong or which privileges the user needs to deploy the schema successfully?

Thank you.

[Updated on: Mon, 07 February 2011 03:20] by Moderator

Report message to a moderator

Re: ORA-31685 and ORA-01932 [message #493263 is a reply to message #493257] Mon, 07 February 2011 03:23 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If what you say is true (and we have no evidence it is) then you cannot what you have (and vice versa).

Regards
Michel
Previous Topic: SQL Loader is missing
Next Topic: How to setup Data Pump resumable error timeout
Goto Forum:
  


Current Time: Fri Mar 29 10:05:04 CDT 2024