Question
AI4Process
GB
Last activity: 7 Aug 2023 10:35 EDT
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.
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.
Pegasystems Inc.
IN
Its described in detail as part of upgrade guide. Plese refer Page number 14 and 15
AI4Process
GB
@PrakashKaragi Thank you for your response.
I have gone though the pages#14 and #15 from the document you have referred. In that context, may I ask -
if I use "Admin/Deployment" user which will own three schema - Rules, Data And Custom.
When I create the JDBC connection for PegaRULES schema, what is recommended option of the following two -
option#1 - <Resource name="jdbc/PegaRULES" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url=<jdbc url> username=<Admin user> password=<DB Password>/>
option#2 - <Resource name="jdbc/PegaRULES" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" url=<jdbc url> username=<PegaRULES user> password=<DB Password>/>
For option#1 - Admin user should has required privileges on PegaRULES schema.
Thanks in advance.