How to create new Schema, User in Oracle Database?

Описание: Create new user in Oracle PL SQL

Oracle tutorial : How to Create New User in Oracle

How to create new Schema, User in Oracle Database?

CREATE USER user_name
IDENTIFIED BY password
DEFAULT TABLESPACE tablespace_name
QUOTA 20M on tablespace_name;

Grant Create session Command to new user:

GRANT CREATE SESSION TO user;

How to Drop New User:

DROP USER username CASCADE;

#techquerypond
https://techquerypond.wordpress.com
https://techquerypond.com
  / techquerypond