1.ot_create_user.sql

--------------------------------------------------------------------------------------
-- Name	       : OT (Oracle Tutorial) Sample Database
-- Link	       : http://www.oracletutorial.com/oracle-sample-database/
-- Version     : 1.0
-- Last Updated: July-28-2017
-- Copyright   : Copyright © 2017 by www.oracletutorial.com. All Rights Reserved.
-- Notice      : Use this sample database for the educational purpose only.
--               Credit the site oracletutorial.com explitly in your materials that
--               use this sample database.
--------------------------------------------------------------------------------------
--------------------------------------------------------------------
-- execute the following statements to create a user name OT and
-- grant priviledges
--------------------------------------------------------------------
--
/* alter session set "_ORACLE_SCRIPT"=true; */
-- create new user
CREATE USER OT IDENTIFIED BY PUMA
    DEFAULT TABLESPACE USERS
      QUOTA 5M ON USERS
  TEMPORARY TABLESPACE TEMP;

-- grant priviledges
GRANT CONNECT, RESOURCE TO OT;