Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VPD Column Masking -- Performance Best Practice Question

Kevin_KJun 5 2013 — edited Jun 7 2013

I am setting up VPD column masking using sec_relevant_cols_opt=>DBMS_RLS.ALL_ROWS option. My policy function should evaluate the access to the columns based on certain roles granted to him. The policy function always appends the where clause predicate with true or false depending on the user's access, Is is advisable to set the STATIC_POLICY => TRUE , or there may be risks involved in using this with column masking.

I did not find any recommendations for column masking related to performance on oracle docs.

Thanks
Kevin

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2013

Added on Jun 5 2013

#database-security, #database-security-general

2 comments

516 views