GRANT ALL PRIVILEGES ON DATABASE odera TO oderaroot;

ALTER TABLE public.t_category   OWNER TO oderaroot;

ALTER TABLE public.t_contact   OWNER TO oderaroot;
ALTER TABLE public.t_rapports   OWNER TO oderaroot;
ALTER TABLE public.t_refetouffementculture   OWNER TO oderaroot;
ALTER TABLE public.t_refevolinfestation   OWNER TO oderaroot;
ALTER TABLE public.t_refparameters   OWNER TO oderaroot;
ALTER TABLE public.t_vues   OWNER TO oderaroot;
ALTER TABLE public.v_vues   OWNER TO oderaroot;
ALTER TABLE public.t_utilisateur   OWNER TO oderaroot;

ALTER TABLE public.v_anneesinvalides OWNER TO oderaroot;
ALTER TABLE public.v_nbitkcultureshiver OWNER TO oderaroot;
ALTER TABLE public.v_classfreqcultureshiver OWNER TO oderaroot;
ALTER TABLE public.v_nbitklabour OWNER TO oderaroot;
ALTER TABLE public.v_classfreqlabour OWNER TO oderaroot;
ALTER TABLE public.v_transdecdeshchim OWNER TO oderaroot;
ALTER TABLE public.v_transdecdeshmeca OWNER TO oderaroot;
ALTER TABLE public.v_coeffdeshmeca OWNER TO oderaroot;
ALTER TABLE public.v_efftravailsuperf OWNER TO oderaroot;
ALTER TABLE public.v_notebineuse OWNER TO oderaroot;
ALTER TABLE public.v_notedatesemis OWNER TO oderaroot;
ALTER TABLE public.v_notedensite OWNER TO oderaroot;
ALTER TABLE public.v_notehoueherse OWNER TO oderaroot;
ALTER TABLE public.v_notedeshmeca OWNER TO oderaroot;
ALTER TABLE public.v_noteecart OWNER TO oderaroot;
ALTER TABLE public.v_noteetouffculture OWNER TO oderaroot;
ALTER TABLE public.v_notelabour OWNER TO oderaroot;
ALTER TABLE public.v_notetravailsuperf OWNER TO oderaroot;
ALTER TABLE public.v_notevariete OWNER TO oderaroot;
ALTER TABLE public.v_noteitk OWNER TO oderaroot;
ALTER TABLE public.v_noteitk0 OWNER TO oderaroot;
ALTER TABLE public.v_noteitkretenue OWNER TO oderaroot;
ALTER TABLE ovv.v_nb_alternatifs OWNER TO oderaroot;
ALTER TABLE ovv.v_ref_note OWNER TO oderaroot;
ALTER TABLE ovv.v_refcritere OWNER TO oderaroot;
ALTER TABLE ovv.v_refmodalite OWNER TO oderaroot;
ALTER TABLE ovv.v_resultat_detaille OWNER TO oderaroot;
ALTER TABLE ovv.v_resultat_detaille_all OWNER TO oderaroot;
ALTER TABLE ovv.v_resultat_scenario OWNER TO oderaroot;
ALTER TABLE ovv.v_resultat_scenario_all OWNER TO oderaroot;
ALTER TABLE ovv.v_scenarios_alternatifs OWNER TO oderaroot;
ALTER TABLE ovv.v_scenarios_initiaux OWNER TO oderaroot;

ALTER SEQUENCE public.t_adventiceetudie_idadventiceetudie_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_category_id_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_contact_id_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_itkdeshmeca_iditkdeshmeca_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_rapports_id_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refadventice_idadventice_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refculture_idculture_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refdecade_numdecade_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refevolinfestation_idevolinfestation_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refleveeadventice_idleveeadventice_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_reflimutildeshmeca_idlimutildeshmeca_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refnotedatesemis_idnotedatesemis_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refnotelabour_idnotelabour_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refnotetravailsuperf_idnotetravailsuperf_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refoutildeshmeca_idoutil_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refparameters_id_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_refvariete_idvariete_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_utilisateur_idutilisateur_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_scenario_idscenario_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.t_vues_id_seq
    OWNER TO oderaroot;
ALTER SEQUENCE public.v_vues_id_seq
    OWNER TO oderaroot;