Re: Export user DDL and privileges?

From: Denis <denis.sun_at_yahoo.com>
Date: Fri, 27 Jul 2012 03:45:19 -0700 (PDT)
Message-ID: <1343385919.50645.YahooMailNeo_at_web122006.mail.ne1.yahoo.com>



Tim,
 

Your script looks nicer and neat. I probably will just add a spool and use yours going forward. Thanks!
 

Denis

From: Tim Hall <tim_at_oracle-base.com>
To: denis.sun_at_yahoo.com
Cc: Chen Zhou <oracle.unknowns_at_gmail.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Friday, July 27, 2012 3:32 AM
Subject: Re: Export user DDL and privileges?

Denis: You might want to consider adding default role and profile. My approach is similar to yours, but I include these extra bits.

http://www.oracle-base.com/dba/script.php?category=script_creation&file=user_ddl.sql

Cheers

Tim...

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 27 2012 - 05:45:19 CDT

Original text of this message