Question

11
Views
ChandramouleeM Member since 2014 11 posts
Cognizant Technologies Solution
Posted: 1 month ago
Last activity: 1 month 1 week ago

Default Database User post Upgrade - PegaAdmin or PegaRules or PegaData

One of my client has recently upgraded Pega version from V7.4 to V8.4. Application Server - Tomcat, Database Server - Oracle.

Our client has used PegaAdmin as default database user to connect to Database during upgrade. Once Upgrade is completed there may three different options for default database user - 

  • Option#1: PegaAdmin as a default user (mentioned in database configuration file - server.xml) - PegaAdmin schema has required privileges and read and write access on PegaRULES and PegaDATA schema.

 

  • Option#2: PegaRULES as a default user (mentioned in database configuration file - server.xml) - PegaRULES schema has required privileges and read and write access on PegaDATA schema.

 

  • Option#3: PegaDATA as a default user (mentioned in database configuration file - server.xml) - PegaDATA schema has required privileges and read and write access on PegaRULES schema.

 

For different clients, I have experienced one of the three options. And the options vary from one client to other.

My question is - Is there any Pega recommended BEST PRACTICE for the default database user to connect Pega Database?

Can anyone please confirm?

I have not found anything specific in Upgrade document.

Same question is applicable for any other Application server and Database Server combination.

Note - the upgrade was out of place and split schema.

 

Thanks in Advance for your response.

 

Pega Platform 8.4 System Administration Government Lead System Architect Upgrade
Share this page LinkedIn