The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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?

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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.