Re: Export user DDL and privileges?

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 25 Jul 2012 14:45:05 -0400
Message-ID: <CAGurbTPrR3LQ3s=ZQimUfug7sMj8P9Cy+wVigHbtE-Y_SGC6VA_at_mail.gmail.com>

Expdp will export object grants for the objects that are included in the export so only those you will get. And if you export schema owner, that means none, because object owner doesn't grant anything to itself.

if you want dull DDL, you may need to do a FULL database expdp and then try to re-generate user sqlfile (see if that contains everything).

Raj

On Wed, Jul 25, 2012 at 2:35 PM, Chen Zhou <oracle.unknowns_at_gmail.com> wrote:
> 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.

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

Received on Wed Jul 25 2012 - 13:45:05 CDT