Re: Entering Users Into Oracle

Quick & Dirty:

If your file looks like

    <username> <password>

I guess it is not too difficult to have every line in your textfile beginning with something like

    start adduser.sql <username> <password>

Save it as a SQL*Plus script. Next, write adduser.sql something like

• adduser.sql create user &1 identified by &2;

Ehhh, I don't know what the syntax to add a user is... Just start the fist script, which will call adduser for each line.

Arjan. Received on Fri Jul 31 1998 - 00:37:30 CDT