Question

1
Replies
44
Views
Close popover
Sv Kumar Manapragada (VIJAY1219)
Accenture

Accenture
IN
VIJAY1219 Member since 2011 10 posts
Accenture
Posted: May 12, 2017
Last activity: April 6, 2018
Closed

Cross schema granting issue while doing pega 7 upgrade

Hi Team ,

Due to client policy violation, we don't have required grants to execute DDL's from one schema to another schema.

As of now we have two schemas one for Rules and other for Data, Lets assume Rules schema - X_RULE and Data Schema - X_DATA.

Individual schema's had full privileges to perform DDL and DML. But X_RULE schema is not allowed to perform DDL's in X_DATA and vice versa.

Please advise with any other alternate approach.

System Administration Upgrades
Moderation Team has archived post