Create users

View the steps to set up users for Oracle to work with WebSphere Portal. Before you begin:


Prerequisites

Installing Oracle

Creating databases

Ensure that you create users and grant the appropriate privileges in Oracle before configuring WebSphere Portal to work with Oracle.

Take care to create users in an environment that has the same settings as the actual runtime environment.

For example, avoid creating a user in an English environment if you plan to use that user in a Turkish environment.

  1. Start the Oracle SQL command line processor 'SQL*Plus' by entering sqlplus /nologon the operating system command prompt

  2. Log in to the Oracle database by executing command connect user/password@database name. For example: system/manager@wpsdb will log the administrative user system with a password of manager into the wpsdb database.

  3. Create the WebSphere Portal user dbdomain.DbUser, where dbdomain is replaced by release, community, or customization.

    1. Log in to the database in which you want to create the new users.

    2. Create the users that you need in the appropriate databases by entering the following commands in the SQL*Plus tool, where user_tablespace is the default tablespace that is identified by the database administrator to store user objects and temp_tablespace is identified to store temporary objects. All names must be in lower case.

      SQL> create user releaseusr identified by password; default tablespace user_tablespace temporary tablespace temp_tablespace;
      

      SQL> create user communityusr identified by password; default tablespace user_tablespace temporary tablespace temp_tablespace;
      

      SQL> create user customizationusr identified by password; default tablespace user_tablespace temporary tablespace temp_tablespace;
      

      SQL> create user jcr identified by password default tablespace users temporary tablespace temp;
      

  4. Connect to the Feedback database:

    1. Enter the following command:

      SQL> connect
      

    2. Enter user-name: username/password@dbname where username is an existing administrative user in the database.

      For example, system/manager@fdbkdb will log the administrative user system with a password of manager into the fdbkdb database.

    3. Create the Feedback user:

      SQL> create user feedback identified by password default tablespace users temporary tablespace temp;
      

    4. Log out of the command line tool using the command SQL> exit.

  5. Connect to the LikeMinds database:

    1. Enter the following command:

      SQL> connect
      

    2. Enter user-name: username/password@dbname, where username is an existing administrative user in the database.

      For example, system/manager@lmdb will log the administrative user system with a password of manager into the lmdb database.

    3. Create the LikeMinds user:

      SQL> create user lmdbusr identified by password default tablespace users temporary tablespace temp;
      

    4. Log out of the command line tool using the command SQL> exit.

  6. Connect to the content database by entering the command SQL> connect.

  7. Enter the following, where username is an existing administrative user in the database. user-name: username/password@dbname For example, system/manager@jcrdb will log the administrative user system with a password of manager into the Oracle database.


Parent topic:

Set up a remote Oracle database on AIX, HP-UX, Linux, and Solaris for a stand-alone production server


Previous topic:

Creating databases


Next topic:

Modifying database properties