From: Syltrem on 17 Jun 2010 13:15
"Syltrem" <syltremzulu(a)videotron.ca> wrote in message
> 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 !
Finally got the official anwer: this is by design (don't know why)
Missing Object Level Grants After Data Pump Schema Level Import [ID
From: gazzag on 18 Jun 2010 06:46
On 17 June, 18:15, "Syltrem" <syltremz...(a)videotron.ca> wrote:
> Finally got the official anwer: this is by design (don't know why)
> Missing Object Level Grants After Data Pump Schema Level Import [ID
Interesting. Thanks Syltrem.