400 IBM WebSphere Portal for Multiplatforms V5 Handbook
4. Run the following command to create the user EJB with password EJB:
SQL> create user EJB
> identified by EJB
> default tablespace USERS
> temporary tablespace TEMP
> ;
5. Run the following command to create the user WCMDBADM with password
WCMDBADM:
SQL> create user WCMDBADM
> identified by WCMDBADM
> default tablespace USERS
> temporary tablespace TEMP
> ;
6. Run the command:
SQL > connect
Type in the user name SYSTEM and password manager1.
7. Run the following command to grant privileges:
SQL > grant connect, resource to PZNADMIN
SQL > grant connect, resource to EJB
SQL > grant connect, resource to WCMDBADM
SQL > grant insert any table to WCMDBADM
8. Quit sqlplus by executing the command: ...