63 lines
2.8 KiB
SQL
63 lines
2.8 KiB
SQL
grant all on DWH.MNP_DW_DONOR to MNP;
|
|
grant all on DWH.MNP_DW_DONOR_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_DONOR_HOC to MNP;
|
|
grant all on DWH.MNP_DW_DONOR_HOC_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_DONOR_HOC_SLA to MNP;
|
|
grant all on DWH.MNP_DW_DONOR_SLA to MNP;
|
|
grant all on DWH.MNP_DW_PORTING to MNP;
|
|
grant all on DWH.MNP_DW_PORTING_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_PORTING_SLA to MNP;
|
|
grant all on DWH.MNP_DW_REC to MNP;
|
|
grant all on DWH.MNP_DW_REC_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC_SLA to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC_SLA_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_HOC_TP_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REC_SLA to MNP;
|
|
grant all on DWH.MNP_DW_REC_SLA_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_TACS to MNP;
|
|
grant all on DWH.MNP_DW_REC_TACS_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REC_TACS_SLA_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_TACS_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_TACS_TP_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REC_TERZEPARTI to MNP;
|
|
grant all on DWH.MNP_DW_REC_TERZEPARTI_DELTA to MNP;
|
|
grant all on DWH.MNP_DW_REPORT_SLA to MNP;
|
|
|
|
grant execute on DWH.CALCOLA_SLA_DONOR to public;
|
|
grant execute on DWH.CALCOLA_SLA_DONOR_HOC to public;
|
|
grant execute on DWH.CALCOLA_SLA_RECIPIENT to public;
|
|
grant execute on DWH.CALCOLA_SLA_RECIPIENT_HOC to public;
|
|
grant execute on DWH.CALCOLA_SLA_RECIPIENT_TACS to public;
|
|
grant execute on DWH.CALCOLA_SLA_TERZEPARTI to public;
|
|
grant execute on DWH.FUN_DATE_FESTIVE to public;
|
|
grant execute on DWH.FUN_DATE_FESTIVE_SUCC to public;
|
|
grant execute on DWH.FUN_GIORNI_LAVORATIVI to public;
|
|
grant execute on DWH.FUN_GIORNI_MENO to public;
|
|
grant execute on DWH.FUN_GIORNI_PIU to public;
|
|
grant execute on DWH.FUN_MENO_ORE_LAVORATIVE to public;
|
|
grant execute on DWH.FUN_ORE_LAVORATIVE to public;
|
|
grant execute on DWH.FUN_PIU_ORE_LAVORATIVE to public;
|
|
grant execute on DWH.FUN_PRIMO_GIORNO_LAVORATIVO to public;
|
|
grant execute on DWH.FUN_ULTIMO_GIORNO_LAVORATIVO to public;
|
|
grant execute on DWH.UPDATE_DONOR_DELTA to public;
|
|
grant execute on DWH.UPDATE_DONOR_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_DONOR_HOC_DELTA to public;
|
|
grant execute on DWH.UPDATE_DONOR_HOC_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_PORTING_DELTA to public;
|
|
grant execute on DWH.UPDATE_PORTING_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_REC_DELTA to public;
|
|
grant execute on DWH.UPDATE_REC_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_REC_HOC_DELTA to public;
|
|
grant execute on DWH.UPDATE_REC_HOC_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_REC_HOC_TERZE_PARTI to public;
|
|
grant execute on DWH.UPDATE_REC_TACS_DELTA to public;
|
|
grant execute on DWH.UPDATE_REC_TACS_DELTA_2 to public;
|
|
grant execute on DWH.UPDATE_REC_TACS_TERZE_PARTI to public;
|
|
grant execute on DWH.UPDATE_REC_TERZE_PARTI to public;
|
|
|
|
|
|
|