Oracle Create User

1. Go directly to the Sqlplus command prompt
Sqlplus/nolog

2. Connect as OS Identity
Sqlplus/as SYSDBA or
Connect/as SYSDBA

3, Normal User login
Sqlplus scott/123456 or
Connect scott/123456 or
Connect Scott/[email protected]

4. Log in as Administrator
Sqlplus sys/123456 as SYSDBA or
Connect sys/123456 as Sysdba

5. Switch users
Conn hr/123456
NOTE: Conn with connect

--Black window create user step:
Sqlplus System/zdyhmanager;
Sqlplus Sys/zdyhmanager as SYSDBA;

1. Create a dedicated test user for your project
Create user adminuser identified by Adminuser;
2. Create a dedicated table space for your project
Create tablespace adminuser_tablespace datafile ' D:\oracle\ADMINUSER. DBF ' size 500m;
3. Let the user use the created tablespace
Alter user adminuser default Tablespace adminuser_tablespace;
4. Authorization to the user
Grant Create Session,create table,create sequence,unlimited tablespace to Adminuser;
5. Set table space to grow automatically
ALTER DATABASE DataFile ' D:\oracle\ADMINUSER. DBF ' autoextend on next 10m MaxSize Unlimited;

6. Set the user to DBA (no data cannot be imported)
Grant DBA to Adminuser;
Or
Alter user adminuser default role DBA;

Oracle Create User