Re: Cloning of a user

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Nov 2001 10:02:22 +0100
Message-ID: <tuf9uulc8sipa0@corp.supernews.com>

"Andreas Boehm" <andi_boe_at_yahoo.com> wrote in message news:1420363e.0111060000.609eeaec_at_posting.google.com...
> Hello,
>
> does anyone know a script that allows to clone a user in oracle via
> SQL similar to the oem? I need to configure a "copy" of a user on
> another instance without having the scripts that created the user.
> Grants, roles, privileges and profiles should be "copied".
>
> regards,
> Andreas

You can do that using export and import
exp ... owner=<olduser>
imp ... fromuser=<olduser> touser=<newuser>

The create user <newuser> statement has to be issued before imp.

Hth,

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Nov 06 2001 - 03:02:22 CST