Re: Export user DDL and privileges?
- From: rjamya <rjamya@xxxxxxxxx>
- To: Chen Zhou <oracle.unknowns@xxxxxxxxx>
- Date: Wed, 25 Jul 2012 14:45:05 -0400
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@xxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
