Data Pump and GRANTs
Date: Thu, 17 Jun 2010 09:27:09 -0400
Message-ID: <OopSn.758458$FK3.734706_at_en-nntp-06.dc1.easynews.com>
Hi
I'm exporting with DataPump using SCHEMA=schemaname, and then I import into another database.
The user I'm exporting has been granted EXECUTE on SYS.DBMS_CRYPTO in the source database.
When I do the import, thus creating the schema into the other database, the imported user is not granted EXECUTE on SYS.DBMS_CRYPTO which caused many procedures/function fail to compile/validate. This is just an example; none of this users grants are imported. On the other hand, all grants that this user grants to other users (for its own objects to be accessed by others) are successfully imported.
If I use IMPDP SQLFILE=somefile, I do not see any grant *to* this user. All
I see is grants *by* this user.
What can I do so that the user be created with all its grants ?
Thanks !
Syltrem
Received on Thu Jun 17 2010 - 08:27:09 CDT