Seting up Oracle 10g XE

The following section is a guide to running Oracle 10g XE and creating user accounts for it.

To start SQL Developer UI go to "Start > All Programs > Oracle 10g > Go To Database Home Page" or type the following URL in your browser "http://127.0.0.1:8081/apex/"

The screen on the right shall appear.

Login as "system" and password as the password entered during installation.

The screen below should appear on successful login.


Do not manipulate the table definitions or data in the"system" account.
To create an user go to Administration > Database Users > Create
The following create user screen appears:

Provide required permissions and click on "Create". Grant DBA role privileges if required.

Internally the following SQL will be executed:

CREATE USER XPBlog IDENTIFIED by 10g;
GRANT CREATE SESSION TO XPBlog;
GRANT CREATE SYNONYM TO XPBlog;... A grant will be executed for each privilege granted.
However, if DBA is selected then the following will be executed:
GRANT DBA TO XPBlog;

"DBA" here is a role which has been granted pre-defined privileges. User defined roles can also be created.