Create user to use data pump and some more questions...
Hi!
Im creating a new user for a customer who will need to be able to do some exports/imports.
Is this enough?
create user user1 identified by password
default tablespace users temporary tablespace temp
grant connect,resource, IMP_FULL_DATABASE, exp_full_database to user1
GRANT read, write ON DIRECTORY country to user1
I will create this user in source and target database.
There will be no problems when doing the import? Like objects being created in the wrong schema?
Regards
U
Im creating a new user for a customer who will need to be able to do some exports/imports.
Is this enough?
create user user1 identified by password
default tablespace users temporary tablespace temp
grant connect,resource, IMP_FULL_DATABASE, exp_full_database to user1
GRANT read, write ON DIRECTORY country to user1
I will create this user in source and target database.
There will be no problems when doing the import? Like objects being created in the wrong schema?
Regards
U
0