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

 Henry Christopher Andrew (Henry Christopher)
RBS

RBS
IN
Henry Christopher Member since 2014 18 posts
RBS
Posted: Jul 11, 2018
Last activity: Jul 12, 2018
Posted: 11 Jul 2018 7:13 EDT
Last activity: 12 Jul 2018 10:09 EDT
Closed

How to change the grant role for the tables created dynamically after running a campaign?

Hi All,

We are running a campaign and a number of tables created dynamically by batch processes. When these are created a select grant is issued to Role A.

With 7.3.1 this should be changed to assign the grant to Role B instead.

Please let me know, is there any piece of code or the steps to change the same.

Thanks,

Henry.

To see attachments, please log in.
Decision Management

Posted: 6 years ago
Posted: 12 Jul 2018 10:08 EDT
Martin Winkler (WINKM)
PEGA
Principal Release Engineer
Pegasystems Inc.
US

We don't do anything in regard to roles or grants within the product.  The table is created by the database user specified by the associated DB rule (e.g. ExternalMKTData).  Any privileges are configured within the database.  The specific method of doing this would differ depending on DB type.

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