To make it possible for soma to insert loglines: create user soma WITH ENCRYPTED PASSWORD 'XXX'; grant select, insert on nonstop_nonstopfile TO soma; grant insert on nonstop_somalogline TO soma; grant all on nonstop_somalogline_id_seq TO soma; grant all on nonstop_somalogline_id_seq TO soma;