Re: Data Pump and GRANTs

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news: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
>

Finally got the official anwer: this is by design (don't know why)

Missing Object Level Grants After Data Pump Schema Level Import [ID 795784.1]

Syltrem Received on Thu Jun 17 2010 - 12:15:31 CDT