scripts to create a user copying from an existing one

[Arturo Galbiati]

Hi Gurus,
I'm looking for a script to allow me to create a new Oracle user copying it from an already existing one? (hpUX11.00 Oracle 8.1.7.4)
TIA.
Art

[RAC_1]

user_name=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $1}'`
user_uid=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $3}'`
group=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $4}'
comment=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $5}'`
home_dir=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $6}'`
user_shell=`grep -i "oracle_user" /etc/passwd|awk -F : '{print $7}'`

useradd -u "$((user_uid+1)) -g $group -G "secondary_groups" -m -k /home_dir -s $user_shell "user_name_you_want"

But why all this??

vipw and cut paste business.

Anil

[Yogeeraj_1]

hi,

try spooling the following sql to a script and in turn running the script on the other database.

select 'create user '||username||' identified by values '''||password||'''
temporary_tablespace '||temporary_tablespace||' default_tablespace '||default_tablespace||';'
from dba_users;

hope this helps!
regards
Yogeeraj

[Yogeeraj_1]

hi,

Is it not at the database level??

Anil gave you the commands to be executed at the OS level...

let us know.

regards
Yogeeraj

[Indira Aramandla]

Hi Art,

If you were asking to create a user in a database same as defined in the other database then as Yaoggeraj gave the script will help you to create the user.

And if you want the user data (if any) to be copied to the other database then export from the source database as owner = and then import to the target database as fromuser= and touser=....parameters.


Indira A

[Arturo Galbiati]

Hi Gurus,
I'm looking for a SQL script to create a new user copying it from another one that alkready exists.
i.e.: copyuser.sql newuser olduser
The script by Yogi it's ok but it only the first step. I need to copy also the roles/priviledges which from old user to the new user.
Art

[Sanjay Kumar Suri · Accepted solution]

Hello

Check the following two links:

http://www.orafaq.com/scripts/sql/cre8like.txt
http://mylxhq.com/clubs/o/html/modules.php?name=News&file=article&sid=107

sks

[Eric Antunes]

You can use Oracle Security Manager from Oracle Enterprise Manager to do this: you have an optoin called "Create Like..."

[Arturo Galbiati]

Thanks sks and Eric