Question
Nordea
SE
Last activity: 6 Mar 2020 4:38 EST
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:--
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:--
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