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 11.2.0.2.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 11.2.0.2.0 - Production
    SQL>
  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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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: