Re: Export user DDL and privileges?
- From: Chen Zhou <oracle.unknowns@xxxxxxxxx>
- To: rjamya <rjamya@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Jul 2012 11:35:36 -0700
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@xxxxxxxxx> 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@xxxxxxxxx>
> wrote:
> > Hi,
> > Does anyone know how to export a user DDL and its roles/privileges using
> > data pump(11.2)?
> > Thanks,
> > Chen
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
