Re: Data Pump and GRANTs

From: gazzag <gareth_at_jamms.org>
Date: Thu, 17 Jun 2010 06:59:48 -0700 (PDT)
Message-ID: <51d364e4-6a0d-48c0-bce6-0cdfd87904ce_at_i31g2000yqm.googlegroups.com>

On 17 June, 14:27, "Syltrem" <syltremz..._at_videotron.ca> wrote:
> 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

Which user are you performing the export and import as? Can you post a logfile of the outputs?

HTH
-g Received on Thu Jun 17 2010 - 08:59:48 CDT