This content has been marked as final. Show 6 replies
Pl post details of OS and database versions.
EXP_FULL_DATABASE and IMP_FULL_DATABASE are powerful roles and should be granted with care. Without these roles, users can only export/import schemas they have access to.
I think your statement “Without these roles, users can only export/import schemas they have access to.” Is false because I tried to export the cm_test schema using the cm_test user ID and password and it failed, see below.
expdp cm_test/cm_test@local schemas=cm_test directory=SR_BACKUP dumpfile=CM_TEST.dmp logfile=SR_TEST_export.log exclude=STATISTICS
Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "CM_TEST.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-01031: insufficient privileges
The OS is windows 7 Prof.
For IMPORT, Whatever objects User need to import, that user should have privileges to create those objects by having privilege “ CREATE <OBJECT TYPE > to import in its own schema itself.
Eg: CREATE TABLE, CREATE TRIGGER,CREATE PROCEDURE...etc
For EXPORT, only CREATE SESSION privileges is enough to export from its own schema.
Minimum is CONNECT & RESOURCE is enough for doing export and import within own schema. To another schema you should need authentication in other schema objects or DBA role
Edited by: user12043395 on Feb 26, 2013 12:18 PM