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:

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