Question

2
Replies
321
Views
Close popover
Gopalakrishnan Krishnanand (Gopal@FT)
Franklin Templeton
Sr Software Engineer
Franklin Templeton
US
Gopal@FT Member since 2008 6 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 account Owner=<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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.