How to create new users in oracle

Have you created a database ?

In Oracle, users are created only within a database.

When an Oracle database is created 2 default administrative users are created.
                                                                                                                  1. SYS
                                                                                                                  2. SYSTEM

Passwords for these users depends on the Oracle version. If the version is lower than 9i (8.17 , 8.16, ..);
                    CHANGE_ON_INSTALL is the default password for SYS and
                    MANAGER is the default password for SYSTEM.

But in 9i there are not default passwords. At the end of the creation of the database you will be prompt for passwords for SYS and SYSTEM.

And if you have a database and you don't know the passwords, try follwing steps;

If your OS is Windows login as the user who installed Oracle (normally Administrator). If it's Linux or UNIX login as Oracle.

Then try the commands:
  If Windows        : set ORACLE_SID=<DB name>
  If Linux or UNIX : export ORACLE_SID=<DB name>

  Then:    

                 'sqlplus /nolog'

You will get a SQL> . Then connect to the database

           If the Oracle version is 9i :

                              connect / as sysdba

           If othe Oracle version is other than 9i :

                             connect internal

Then you will be connected to the database with full privileges. Now you can get changed the passwords for SYS and SYSTEM.

                          alter user SYSTEM identified by <new password>


Have fun. Oracle is a great DBMS.


                       

This is an example of creating schema/users. You have to think also what will be the default tablespace for the users.

DROP USER LSCONTACTS CASCADE;
DROP USER LSCONTAINER CASCADE;
DROP USER LSDOCUMENTS CASCADE;
DROP USER LSIDMAP CASCADE;
DROP USER LSMEDICAL CASCADE;
DROP USER LSSYSTEM CASCADE;
DROP USER LSUSER CASCADE;


CREATE USER LSCONTACTS IDENTIFIED BY LSCONTACTS
DEFAULT TABLESPACE TSDCONTACTS   TEMPORARY TABLESPACE TSTEMPORARY
QUOTA UNLIMITED ON TSDCONTACTS;

CREATE USER LSCONTAINER IDENTIFIED BY LSCONTAINER
DEFAULT TABLESPACE TSDCONTAINER  TEMPORARY TABLESPACE TSTEMPORARY
QUOTA UNLIMITED ON TSDCONTAINER;


CREATE USER LSDOCUMENTS  IDENTIFIED BY LSDOCUMENTS
DEFAULT TABLESPACE TSDDOCUMENTS  TEMPORARY TABLESPACE TSTEMPORARY
QUOTA UNLIMITED ON TSDDOCUMENTS;

CREATE USER LSIDMAP  IDENTIFIED BY LSIDMAP
DEFAULT TABLESPACE TSDIDMAP   TEMPORARY TABLESPACE    TSTEMPORARY
QUOTA UNLIMITED ON TSDIDMAP;

CREATE USER LSMEDICAL  IDENTIFIED BY LSMEDICAL
DEFAULT TABLESPACE TSDMEDICAL  TEMPORARY TABLESPACE   TSTEMPORARY
QUOTA UNLIMITED ON TSDMEDICAL;

CREATE USER LSSYSTEM    IDENTIFIED BY LSSYSTEM
DEFAULT TABLESPACE TSDSYSTEM   TEMPORARY TABLESPACE  TSTEMPORARY
QUOTA UNLIMITED ON TSDSYSTEM;

CREATE USER LSUSER IDENTIFIED BY LSUSER
DEFAULT TABLESPACE SYSTEM    TEMPORARY TABLESPACE TSTEMPORARY;


GRANT create procedure, create session,create table,create type,create view,create synonym TO LSCONTACTS;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSCONTAINER;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSDOCUMENTS;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSIDMAP;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSMEDICAL;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSSYSTEM;
GRANT create procedure, create session,create table,create type,create view,create synonym TO LSUSER;