Question

2
Replies
287
Views
Gopal@FT Member since 2008 4 posts
Franklin Templeton
Posted: 2 years ago
Last activity: 1 year 11 months ago
Closed

Database account privileges

Hello,

As a part of security lockdown we scanned our PRPC 7.2 database and found the below. We are using Oracle 12C RAC database with split schema.

Object privilege granted to accountOwner=<RULES_SCHEMA>;Grantee=<DATA_SCHEMA>;Object Name=PC_INDEX_FLOWREF;Privilege=ON COMMIT REFRESH

There are several similar findings for Privilege=ON COMMIT REFRESH on several objects, reported as a violation on both schemas. Is this privilege required for runtime operations? or Is this needed only at the time of install/upgrade that can now be revoked?

P.S We upgrade from PRPC 6.1 SP2 to PRPC 7.2.2.

Thanks

Gopal

***Edited by Moderator Marissa to update platform capability tags****

Security Low-Code App Development Installation and Deployment Data Integration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn