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 ;