Automatic User creation Options

[Atulya Swayankar]

I am doing my master project on oracle Database. I need to create a PL/SQL script to create user automatecally. Name of the users i am supposed to get from some table (say pr_id of table persons).

please help me to overcome this problem.
thaNKs in advance...

regards, Atulya (atulya.swayankar[at]gmail[dot]com)

[dave]

wellw hat have you come up with so far seeing as though we don't do homework on here

[Atulya Swayankar]

i am very sorry if you thouht like that. I am learner and i got stuck at that point and no one is here to guide me. I am not telling you to write code. it would be even better if you give me some clue regarding this so that i could leran even more out of that.

[burleson]

Hi Atulya,

>> I am learner and i got stuck at that point and no one is here to guide me.

Oracle is not for neophytes, please read this!

http://www.dba-oracle.com/t_how_to_become_an_oracle_dba.htm

You should have several years of college computer science done BEFORE starting to learn Oracle.

I'll give you a hint,

You want to generate SQL from the values of the other SQL, like this:

CODE

spool runme.sql

select 'create user'||someval||';' from mytable;

spool off

@runme

[Atulya Swayankar]

@Donald thank you.. for links..

thanks for the help. Finally I have done automatic user creation..........