Question

2
Replies
37
Views
AnandP Member since 2013 141 posts
Swedbank AB
Posted: February 21, 2020
Last activity: March 6, 2020
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:--

  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
Share this page LinkedIn