HOW TO CREATE USER IN ORACLE

 -- SYS/Pass

--STEP 1) FIRST CHECK THE TABLESPACE NAME AND TEMP TABLESPACE AVAILABLE IN DATABASE

SELECT NAME FROM V$TBLESPACE;

SELECT TABLESPACE_NAME FROM DBA_TEMP_FILES;

-- STEP 2) CREATE USER

 CREATE USER quium IDENTIFIED BY quium
 default tablespace USERS
 TEMPORARY TABLESPACE TEMP
 QUOTA UNLIMITED ON USERS;

STEP 3)  GRANT PRIVILEGE BELOW

GRANT CONNECT, RESOURCE TO quium;

STEP 4)  CONNECT USER

conn quium/quium



scripts

//
SQL*Plus: Release 12.2.0.1.0 Production on Mon May 27 00:56:50 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select  name from v$tablespace;

NAME
------------------------------
SYSAUX
SYSTEM
UNDOTBS1
USERS
TEMP


22 rows selected.

SQL> select  tablespace_name from dba_temp_files;

TABLESPACE_NAME
------------------------------
TEMP

SQL> CREATE USER quium IDENTIFIED BY quium
  2  default tablespace USERS
  3  TEMPORARY TABLESPACE TEMP
  4  QUOTA UNLIMITED ON USERS;

User created.

SQL> grant connect, resource to quium;

Grant succeeded.

conn quium/quium