Answers for "add schema to oracle database"

SQL
1

oracle db create new schema

-- 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;
Posted by: Guest on October-02-2020
1

create schema oracle sql 19c

CREATE USER smith IDENTIFIED BY password;
Posted by: Guest on August-17-2020
0

create schema oracle sql 19c

GRANT CREATE TABLE TO smith;
Posted by: Guest on August-17-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language