oracle db create new schema
snippet in sql

create schema oracle sql 19c

user9744

CREATE USER smith IDENTIFIED BY password;

oracle db create new schema

user9026

-- 1st Step
CREATE USER user_name IDENTIFIED BY password;
-- 2nd step
GRANT RESOURCE TO user_name;
GRANT CONNECT TO user_name;
GRANT CREATE VIEW TO user_name;
GRANT CREATE SESSION TO user_name;
GRANT UNLIMITED TABLESPACE TO user_name;

create schema oracle sql 19c

user2789

GRANT CREATE TABLE TO smith;