Create users

View the steps to set up users for Oracle to work with WebSphere Portal.

Before you begin:

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 to use that user in a Turkish environment.

This topic provides instructions on creating a configuration database user. To create a runtime database user, repeat the steps in this topic.

  1. Start the Oracle SQL command line processor 'SQL*Plus' by entering sqlplus /nolog on the OS 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;
        GRANT UNLIMITED TABLESPACE TO releaseusr;

        SQL> create user communityusr identified by password
        default tablespace user_tablespace temporary tablespace temp_tablespace;
        GRANT UNLIMITED TABLESPACE TO communityusr;

        SQL> create user customizationusr identified by password
        default tablespace user_tablespace
        temporary tablespace temp_tablespace;
        GRANT UNLIMITED TABLESPACE TO customizationusr;

        SQL> create user jcr identified by password 
        default tablespace user_tablespace 
        temporary tablespace temp_tablespace;
        GRANT UNLIMITED TABLESPACE TO jcr

  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 user_tablespace 
        temporary tablespace temp_tablespace;
        GRANT UNLIMITED TABLESPACE TO feedback

    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 user_tablespace 
        temporary tablespace temp_tablespace;
        GRANT UNLIMITED TABLESPACE TO lmdbusr

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

  6. To verify that you can connect to the database with the user ID and password that you just created:

    1. Enter the SQL> connect command to connect to the content database.

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

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


Related tasks


Manually creating users and granting privileges for Oracle: wp7 August 30, 2010 11:15:11 PM

 


        +

        Search Tips   |   Advanced Search