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 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

  • http://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm

1 thought on “How to create Oracle users in Oracle 11g XE

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

Leave a Comment

Your email address will not be published. Required fields are marked *