Question

2
Replies
53
Views
Anand Pandey (AnandP)
Swedbank AB
Pega Platform Engineer
Swedbank AB
SE
AnandP Member since 2013 151 posts
Swedbank AB
Posted: February 21, 2020
Last activity: March 6, 2020
Posted: 21 Feb 2020 4:17 EST
Last activity: 6 Mar 2020 4:38 EST
Closed
Solved

Need Help With Dual-User Setup

Hi,

We are configuring dual-user setup for our Pega application and we are referring to below installation guide:--

https://community.pega.com/knowledgebase/documents/pega-platform-83-installation-guide-websphere-and-oracle

For BASE user setup, it is written that it should have "Basic read and write access to data and rules tables including rules resolution"

Since it is not clearly mentioned about the scripts which should be given to data schema owner, we can think of below only but please advise if something needs to be added/removed here:--

Hi,

We are configuring dual-user setup for our Pega application and we are referring to below installation guide:--

https://community.pega.com/knowledgebase/documents/pega-platform-83-installation-guide-websphere-and-oracle

For BASE user setup, it is written that it should have "Basic read and write access to data and rules tables including rules resolution"

Since it is not clearly mentioned about the scripts which should be given to data schema owner, we can think of below only but please advise if something needs to be added/removed here:--

  GRANT FLASHBACK ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT DEBUG ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT QUERY REWRITE ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT ON COMMIT REFRESH ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT READ ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT REFERENCES ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT UPDATE ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT SELECT ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT INSERT ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT INDEX ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT DELETE ON {Rule Schema Name}.{Rule Schema Table Name} TO {Data Schema Name};   GRANT A

Pega Platform 8.3.1 System Administration Financial Services System Architect
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.