To create a user in Oracle Database, you need to use the CREATE USER command.
For example:
CREATE USER new_user
IDENTIFIED BY new_password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 10M ON users;
This command will create a new user called “new_user” with a password of “new_password”. It will also assign the user a default tablespace of “users” and a temporary tablespace of “temp”. It will also assign the user a quota of 10MB on the “users” tablespace.