Assuming Oracle is installed and running…

1. Log into a command console with the oracle user.

> su - oracle

2. Creat a file and place the text below.

drop user npn6 cascade;
create user npn6 identified by npn6;
grant resource, connect, create view to npn6;
commit;

3. log into sqlplus to run the file you created

>sqlplus / as sysdba

4. from the sqlplus console, you may run the file you created, assuming the file name is user.sql

SQL>@user.sql

5. you should get an output like

User created.

Grant succeeded.

Commit complete.

SQL>

5. then you may exit. You have created a user npn6

—

I tried finding this over google, but i guess i’m not good at hunting

Thanks to Ken del Rosario our “Oracle Main Man”.

Posted on 02.18.08 to Oracle by Julz. Tagged "user creation", Oracle. Subscribe to follow comments on this post. One comment. Add your thoughts or trackback from your own site.

• BROWSE / IN TIMELINE
• « Hello world! Hello Exist Blog!
• » Dumping data to Oracle 10g via command line

• BROWSE / IN Oracle
• » Dumping data to Oracle 10g via command line