You can easily create a database user for PPM using suitable administration components, such as Database control or EM Database Express.
Assign the database user the roles CONNECT and RESOURCE and ensure that the user has sufficient privileges for accessing tablespaces.
Alternatively, you can create the user with an SQL script. Provided that the PPMDATA default tablespace and the TEMP tablespace exist, you can use the following script to create database users for PPM:
prompt This script generates a (new) user.
prompt when using TEMPORARY memories
prompt Please specify the target database and
prompt connect as "SYSTEM" user.
accept servername prompt 'Target database : '
connect system@&servername
accept newusername prompt 'Name of user :'
accept newuserpass prompt 'Password of user :'
create user &newusername
identified by &newuserpass
default tablespace PPMDATA
temporary tablespace TEMP;
grant CONNECT to &newusername;
grant RESOURCE to &newusername;
connect &newusername/&newuserpass@&servername
accept ende prompt 'Execution finished <return>'
exit
Warning
Please avoid using system tablespaces for a PPM database user.