Implementing column-level access policies
In row-level access policies, the policy is applied regardless of the selected columns.
However, when implementing restrictions at the column level, the policy is not enforced until the columns protected by the policy are included in the DML statement. As we will see, this option can also be used to mask column data when desired. When column masks are also enforced by the policy, the records that don't conform to the defined criteria have their column values hidden by the policy and displayed as nulls instead.
In this recipe we will create two users;
JWHALEN. We will declare a policy named
EMPLOYEES_SALCOMM_PLC that will protect the
commision_pct columns from the