grant select on rich700_pixel                 to hades_ana;
grant select on rich700_pmt_pixel             to hades_ana;
grant select on rich700_lookup_vers_at_date  to hades_ana;
grant select on rich700_trb3lookup_vers  to hades_ana;
grant select on rich700_trb3lookup_data  to hades_ana;
grant select on rich700_trb3lookup_data_view  to hades_ana;
grant execute on RICH700_par_query      to hades_ana;


grant select on rich700_pixel                  to ana_query;
grant select on rich700_pmt_pixel             to ana_query;
grant select on rich700_lookup_vers_at_date  to hades_ana;
grant select on rich700_trb3lookup_vers  to ana_query;
grant select on rich700_trb3lookup_data  to ana_query;
grant select on rich700_trb3lookup_data_view  to ana_query;
grant execute on RICH700_par_query      to hades_ana;

--grant insert on rich700_trb3lookup_vers to halo;
--grant insert on rich700_trb3lookup_data to halo;

-- any other operator acounts?

--grant insert on rich700_trb3lookup_vers to halo;
--grant insert on rich700_trb3lookup_data to halo;


grant insert, update, delete on rich700_trb3lookup_vers to hanal2;

--for testing/compilation needed?
grant insert  on rich700_trb3lookup_data to hades_ana;
grant insert  on rich700_trb3lookup_vers to hades_ana;