Skip to main content

ACCESS POLICY Load Issue

  • August 26, 2015
  • 4 replies
  • 20 views

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?

4 replies

Adrian_Oprea_1
Forum|alt.badge.img+1
  • Participating Frequently
  • August 27, 2015

What is the definition of the access policy?

 


MichaelPacocha
  • Author
  • New Participant
  • August 27, 2015

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
  • Author
  • New Participant
  • September 4, 2015

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
  • New Participant
  • November 10, 2015

Hi. Have you found a solution?