Creating Multiple User

[seung]

Pls I Want To Know If I Can Create Multiple Users At The Same Time On The Oracle Database,if Yes Pls Let Me Have The Syntax.

Example :say I Want To Create 10 Users With Diff Names ,vendorapp,hrapp,salesapp,stocksapp Et.c

Case 1
Create User Vendorapp Identified By ------

My Question Is That Instaed Of Havin To Do It One By One Can I Run A Syntax That Will Take Care Of Everything.

[goudelly]

Hi,

You can create the script in text editor : for ex: user.sql

create user abc identified by abc;
create user ijk identified by ikj;
create user lmn identified by lmn;
create user xyz identified by xyz;

In sql prompt :

@user.sql;

it will create the user one by one from the script.

Thanks,

Mohan Reddy

Pls I Want To Know If I Can Create Multiple Users At The Same Time On The Oracle Database,if Yes Pls Let Me Have The Syntax.

Example :say I Want To Create 10 Users With Diff Names ,vendorapp,hrapp,salesapp,stocksapp Et.c

Case 1
Create User Vendorapp Identified By ------

My Question Is That Instaed Of Havin To Do It One By One Can I Run A Syntax That Will Take Care Of Everything.