How to create user in oracle

How to create user in ORACLE?


Login with system admin in sqlplus

Step 1 : 

C:\Users\atul>sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 1 14:42:56 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Enter user-name: sys as sysdba
Enter password:


Execute following commands

Step 2 :

CREATE USER ap2010 IDENTIFIED BY ap2010 DEFAULT TABLESPACE "SYSTEM" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT;
GRANT CONNECT TO ap2010 ;
GRANT RESOURCE TO ap2010 ;
GRANT CREATE VIEW TO ap2010 ;
GRANT UNLIMITED TABLESPACE TO ap2010 ;


Comments