Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does VPD or OLS add an additional column to the protected table?

April 26, 2017additional column ols protected Table vpd

0

Posted

Does VPD or OLS add an additional column to the protected table?

1 Answer

0

Posted

When you apply an Oracle Label Security (OLS) policy to a table, the policy adds an additional column to the table. The name of this column needs to be specified when the policy is initially created. An existing column can be used to store the OLS row labels. This column must have the NUMBER(10) datatype. Virtual Private Database (VPD) does not add an additional column to the protected table.