Data Pump and GRANTs
in [Oracle]
|
From: Syltrem on 17 Jun 2010 13:15 "Syltrem" <syltremzulu(a)videotron.ca> wrote in message news:OopSn.758458$FK3.734706(a)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
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 > 795784.1] > > Syltrem Interesting. Thanks Syltrem. -g |