Portal, V6.1

---

 

Granting privileges

This section provides information on granting privileges on Oracle.

Grant these two default roles and their corresponding default privileges to each of the users that you created:

• CONNECT

• RESOURCE

To grant WebSphere Portal users the appropriate privileges, perform the following steps:

1. Log in to the database in which you want to grant privileges to users.

2. Log in to SQLPlus as system/manager or another administrative user.

3. When granting privileges on dba_pending_transactions, be logged in as sysdba.

4. From the prompt, type the following command, where username represents the database user, to grant privileges: SQL> grant connect, resource to username;

To implement the architecture based on the recommendations in the planning section, follow these steps:

1. Start SQL*Plus, the Oracle SQL command line tool, and enter the following commands to log in:

   $ sqlplus user-name: username/password@dbname
   

   where username is an existing administrative user in the database. For example, system/manager@release will log the administrative user system with a password of manager into the release database.

2. Connect to the WebSphere Portal, JCR, Feedback, and LikeMinds databases by entering the following command:

   SQL> connect user-name: username/password@dbname
   

   where username is an existing administrative user in the database. For example, system/manager@wpsdb will log you in to the wpsdb database.

3. Grant the required privileges:

   The insert privilege is required only to import the database during WebSphere Portal configuration. After configuring WebSphere Portal, this privilege can be revoked, if desired.

   SQL> grant select on dba_pending_transactions to dbdomain.dbusr; SQL> grant connect, resource to dbdomain.dbusr;
   

   SQL> grant select on dba_pending_transactions to feedback; SQL> grant connect, resource, create session to feedback;
   

   SQL> grant select on dba_pending_transactions to lmdbusr; SQL> grant connect, resource, create session to lmdbusr; SQL> grant insert any table to lmdbusr;
   

   SQL> GRANT create session, alter session, create table,  create view, create trigger, create library,  create tablespace, alter tablespace, drop tablespace,  execute any procedure, unlimited tablespace,  create sequence to jcr; 
   

   SQL> grant select on dba_pending_transactions to jcr; SQL> grant connect, resource to jcr; SQL> grant insert any table to jcr;
   

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

 

Parent topic

Create users and grant privileges for Oracle

 

Related tasks

http://www.ibm.com/support/docview.wss?uid=swg21196663

---