Here is how it’s done.
- Log on as SYSTEM user
C:\Users\delta1>sqlplus system SQL*Plus: Release 184.108.40.206.0 Production on Thu Feb 20 12:01:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Express Edition Release 220.127.116.11.0 - Production SQL>
- Execute the CREATE USER command
SQL> create user user_name identified by user_password;
- Provide permissions to the new user, only the ones it needs
SQL > grant connect ,create table, create session, resource, create trigger, create procedure ,create view, create synonym, create sequence to user_name;
That’s it, very simple but I’m sure it has been a challenge for some of us. Sources