How to create Oracle users in Oracle 11g XE

Here is how it’s done.

  1. Log on as SYSTEM user
    C:\Users\delta1>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
  2. Execute the CREATE USER command
    SQL> create user user_name identified by user_password;
  3. 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

One comment

  1. Just FYI, usually the password for system is “system” (without quotes)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: