Re: Oracle 11g new features

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 22 Mar 2007 17:41:35 -0700
Message-ID: <1174610493.914778@bubbleator.drizzle.com>

Brian Peasland wrote:
> Matthias Hoys wrote:

>> How about:
>>
>> CREATE USER LIKE ...

>
> That would be a great idea! Either that, or the ability to use
> DBMS_METADATA.GET_DDL to reverse engineer the CREATE user statement
> *along with* the necessary GRANT statements.
>
>
>
> Cheers,
> Brian

You mean like this?

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 22 17:39:44 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> set long 1000000
SQL> select dbms_metadata.get_ddl('USER', 'UWCLASS') from dual;

DBMS_METADATA.GET_DDL('USER','

---

    CREATE USER "UWCLASS" IDENTIFIED BY VALUES '6DC6701F46477E93'

       DEFAULT TABLESPACE "UWDATA"
       TEMPORARY TABLESPACE "TEMP"

SQL> Now if only it provided quotas and privs. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Mar 22 2007 - 19:41:35 CDT