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 188.8.131.52.0 Production on Pe Joulu 7 10
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Oracle Database 11g Express Edition Release 184.108.40.206.0 -
SQL> create user simple identified by "welcome1";
SQL> grant create session to simple;
SQL> grant resource to simple;