Granting privileges

View 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...

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...

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:

Manually creating users and granting privileges for Oracle

Related information

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

---