Re: Cloning of a user

From: Andreas Boehm <andi_boe_at_yahoo.com>
Date: 6 Nov 2001 06:00:16 -0800
Message-ID: <1420363e.0111060600.2a6062d8@posting.google.com>

Hi,

> > 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".
> 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.

does this mean, the import will import all grants, privileges, roles and profiles of the user, if this user will be created with no grants, no roles and without any privilges?

regards,
Andreas Boehm Received on Tue Nov 06 2001 - 08:00:16 CST