2 Replies Latest reply: Jun 7, 2013 4:45 AM by Harm Joris ten Napel-Oracle RSS

    VPD Column Masking -- Performance Best Practice Question

    Kevin_K
      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