Re: Export user DDL and privileges?
- From: Denis <denis.sun@xxxxxxxxx>
- To: Tim Hall <tim@xxxxxxxxxxxxxxx>
- Date: Fri, 27 Jul 2012 03:45:19 -0700 (PDT)
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@xxxxxxxxxxxxxxx>
To: denis.sun@xxxxxxxxx
Cc: Chen Zhou <oracle.unknowns@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>
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...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
