Re: Export user DDL and privileges?

From: Chen Zhou <oracle.unknowns_at_gmail.com>
Date: Wed, 25 Jul 2012 11:35:36 -0700
Message-ID: <CAJUY3dRx5Ks0R3J32soOV81uX7DN+58+deA2Y9vjrYJrYa6DQw_at_mail.gmail.com>

I tried expdp user/pass directory=xxx dumpfile=yyy schemas=user1 include=user
then impdp sqlfile=XYZ
The user DDL was generated without its roles, privileges. Then I tried expdp user/pass directory=xxx dumpfile=yyy schemas=user1, then impdp sqlfile=XYZ
The user DDL generated has its roles, system privileges, but does not have the object privileges. I will just need to get that outside of data dump then.
Regards,
Chen
On Wed, Jul 25, 2012 at 10:44 AM, rjamya <rjamya_at_gmail.com> wrote:

> expdp user/pass directory=xxx dumpfile=yyy schemas=user1,user2 include=user
>
> and then run impdp with sqlfile option
>
> On Tue, Jul 24, 2012 at 5:50 PM, Chen Zhou <oracle.unknowns_at_gmail.com>
> wrote:
> > Hi,
> > Does anyone know how to export a user DDL and its roles/privileges using
> > data pump(11.2)?
> > Thanks,
> > Chen
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 25 2012 - 13:35:36 CDT