Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sv Kumar Manapragada (VIJAY1219)
Bank of America
Sv Kumar Manapragada
Bank of America
IN
VIJAY1219 Member since 2011 13 posts
Bank of America
Posted: May 12, 2017
Last activity: Apr 6, 2018
Posted: 12 May 2017 6:37 EDT
Last activity: 6 Apr 2018 19:26 EDT
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.

To see attachments, please log in.
Updates

Posted: 7 years ago
Posted: 12 May 2017 7:04 EDT
Dhevendra Earva (earvd)
PEGA
Senior Director of Cloud Engineering
Pegasystems Inc.
IN

You can generate the DDL for required step in the upgrade and ask DBA to execute the scripts as admin user.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice