You can easily create a database user for PPM using suitable administration components, such as Database control or EM Database Express.
Note that user names are case sensitive in Oracle 18 and 19. PPM supports only upper case user names.
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:
-- USER SQL
CREATE USER "UMG_EN" IDENTIFIED BY "umg_en"
DEFAULT TABLESPACE "PPMDATA"
TEMPORARY TABLESPACE "TEMP";
-- ROLES
GRANT "CONNECT" TO "UMG_EN" ;
GRANT "RESOURCE" TO "UMG_EN" ;
-- SYSTEM PRIVILEGES
GRANT UNLIMITED TABLESPACE TO "UMG_EN" ;
Warning
Please avoid using system tablespaces for a PPM database user.