Tutorial 1. Part 4 - creating a new user in DB for our schemas

Setup

Some common activities are normally needed after you have installed SOA Suite and start to develop a new use case: for example you might create new username in the database so that all the tables related to this development are grouped together. If you create own user, you will need to also create a database resource on the WebLogic server side that handles the connection pool and so on.

Creating new database user with SQLPLus

Before we start developing our application, let’s first create own user for this application so that all generated database tables will belong to that user.

We can do this for example with sqplus from the command line:

>Sqlplus sys as sysdba

This starts the sqplus command and tells that we want to log on as user sys and the user should assume the role of system administrator. Then Oracle prompts for the password you gave when you installed the DB needed by it (use the admin password you selected). Finally create the user with the “create user” command.

C:\Windows>sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Pe Joulu 7 10

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 -

SQL> create user simple identified by "welcome1";

User created.

SQL> grant create session to simple;

Grant succeeded.

SQL>

SQL> grant resource to simple;

Grant succeeded.

SQL>