Create a database user

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.