Hello AVs,
if we set up access policy like this for the set of columns of a table:
create access policy on htest.anat_aithmata for column EPWNYMO
CASE
when enabled_role('encrypted_producer') then VoltageSecureProtect(remap_greek(EPWNYMO::VARCHAR) using parameters format='greek_test')
else EPWNYMO
END enable;
will it be possible to encrypt the data while loading? Like this:
copy htest.anat_aithmata (KENTRO,PRWT,HMEROM,EPWNYMO_raw FILLER VARCHAR,ONOMA_raw FILLER VARCHAR,PATR_raw FILLER VARCHAR,EPAG_raw FILLER VARCHAR,
ODOS,NUM,SYNOIK,EIDOS,SORT,ENTOLH,ARX_PRWT,KAT_EX,ST,
KOMBOS,ARX_HMER,ETP_PAR,OROFOS,TAXKWD,POLH,TLFSYN,YLIKA,NOMIMO,KATHG,XOROS,ODOS_E,NUM_E,SYNOIK_E,TAXKWD_E,POLH_E,DIAKDATE,STDIAKTHN,TLF_KATAG,EXOYSIOD,SYNTSYSK,HMGEN,TOPGEN,XAK,ATELWS,
AFM_raw FILLER VARCHAR,DOY,ADT_raw FILLER VARCHAR,ADT_COD,ADT_EKD_ARXI,ADT_EKD_DATE,EKPROSWPOS,PARATHR_APOLOG,PARATHR_SYNERG,KMAS,FYSI,BCCS_ENTOLH,TRANSACTION_ID,PRODUCT,
AITIA_OD,SLA,NEA_POLYK,LLU_XAK,LLU_SYND,PAROXOS_ID_FROM_LEIT,TEK,WLR,RANTDATE,WRARIO,RANTRMKS,HM_DESM,LAST_CDC,
EPWNYMO as VoltageSecureProtect(remap_greek(EPWNYMO_raw) using parameters format='greek_test'),
ONOMA as VoltageSecureProtect(remap_greek(ONOMA_raw) using parameters format='greek_test'),
PATR as VoltageSecureProtect(remap_greek(PATR_raw) using parameters format='greek_test'),
EPAG as VoltageSecureProtect(remap_greek(EPAG_raw) using parameters format='greek_test'),
AFM as VoltageSecureProtect(remap_greek(AFM_raw) using parameters format='greek_test'),
ADT as VoltageSecureProtect(remap_greek(ADT_raw) using parameters format='greek_test'))
from local '/Users/fivos/Documents/Performance/ote/AITHMATA_201904231307.csv' delimiter ',';
