Datapump : import users grant
451915Jul 11 2007 — edited Jul 11 2007Hi,
I did the export below in one of my database server :
expdp .... dumpfile=test.dmp full=y include=profile,role,user,grant
Then i try to import all this in my target database with the following command :
impdp user/user directory=dpump_dir dumpfile=test.dmp parfile=exclude.par
The exclude.par only contains user i don't want to import.
Everything seems to work fine.
But when i look to the grant of my user, grants are missing.
For example, none of my imported user have the role "connect".
Is this normal behaviour, is there special command to have role granted to users ?
Thanks for answer.