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.

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.