Question

2
Replies
302
Views
Close popover
Gopalakrishnan Krishnanand (Gopal@FT)
Franklin Templeton
Sr Software Engineer
Franklin Templeton
US
Gopal@FT Member since 2008 4 posts
Franklin Templeton
Posted: September 26, 2018
Last activity: October 5, 2018
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 System Administration Installation and Deployment Upgrades Data Integration
Moderation Team has archived post