ACCESS POLICY Load Issue

MichaelPacocha

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?

Adrian_Oprea_1

What is the definition of the access policy?

 

MichaelPacocha

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.

MichaelPacocha

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.

Kkso

Hi. Have you found a solution?