IBM WebSphere Portal for Multiplatforms V5 Handbook

402 IBM WebSphere Portal for Multiplatforms V5 Handbook

Example 8-6 Result of Select syntax command

GRANTEE GRANTED_ROLE ADM DEF

------------------------------ ------------------------------ --- ---

WPSDBUSR CONNECT NO YES

WPSDBUSR RESOURCE NO YES

SQL>

2. Check that the privileges of the insert any table is granted to the user.

Here is the method to check if the privilege

insert any table is granted to

wcmdbadm in the database wpcp50.

a. Log in using the oracle user account on machine 3.

# su - oracle

$

b. Run the following commands:

$ sqlplus /nolog

Example 8-7 Result of sqlplus command

SQL*Plus: Release 9.2.0.1.0 - Production ...