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?
ACCESS POLICY Load Issue
+1What 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?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
