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