-- Remet tous les droits à l'utilisateur lesia
-- A utiliser quand on fait des modifications sur la structure
-- des tables

SET search_path = apis, public, pg_catalog;

-- apis_data

alter table hisaki_data owner to lesia;
alter table nephtys_data owner to lesia;
alter table bastet_data owner to lesia;
alter table apis_data owner to lesia;

-- apis_secondary_targets

alter table bastet_secondary_targets owner to lesia;


-- apis_dataset

alter view apis_dataset owner to lesia;


-- epn_core

alter view epn_core owner to lesia;


-- concat_selected_fields

alter function concat_selected_fields(text,  text, text) owner to lesia;

-- views

alter view apis_targets owner to lesia;
alter view apis_telescopes owner to lesia;
alter view apis_campaign owner to lesia;
alter view apis_products owner to lesia;
alter view apis_secondary_targets owner to lesia;

