Create user for WCS

drop user suresh1usr cascade;

drop tablespace suresh1db including contents and datafiles;

CREATE TABLESPACE suresh1db DATAFILE '/oracle/u01/app/oracle/oradata/suresh1/suresh1db.dbf' SIZE 4M AUTOEXTEND ON NEXT 2M MAXSIZE UNLIMITED;

CREATE USER suresh1usr IDENTIFIED BY suresh1usrs00 DEFAULT TABLESPACE suresh1db QUOTA UNLIMITED ON suresh1db;

grant all privileges to suresh1usr;

ALTER USER suresh1usr TEMPORARY TABLESPACE TEMP;

CONNECT suresh1usr/suresh1usrs00;

CREATE SCHEMA AUTHORIZATION suresh1usr;