How to create Oracle users in Oracle 11g XE

Here is how it’s done.

  1. Log on as SYSTEM user
C:Usersdelta1>sqlplus system
SQL*Plus: Release 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 - Production
  1. Execute the CREATE USER command
SQL> create user user_name identified by user_password;
  1. 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.