ACCESS POLICY Load Issue
We've created an ACCESS POLICY on a table and it works great for select. We are in the initial stages of testing and get an error when we try to load the table. Using an unrestricted userid we receive the message - ERROR 6593: Unable to MERGE: "Access denied due to active access policy on table. Has anyone seen this?
0
Comments
What is the definition of the access policy?
CREATE ACCESS POLICY ON ods_owner.PS_PROV_PHONE FOR COLUMN T_PHONE_NUM
CASE
WHEN enabled_role('vertica_noPHI_role') then null
ELSE T_PHONE_NUM
END
ENABLE;
We opened case 00047780 yesterday if that helps. Thanks.
We changed the policy as directed to:
CREATE ACCESS POLICY ON ods_owner.PS_CLIA FOR COLUMN I_FEIN
CASE WHEN enabled_role('vertica_noPHI_role') THEN CAST('x' AS VARCHAR)
ELSE I_FEIN
END
ENABLE;
We still get the same error.
Hi. Have you found a solution?