CREATE ROLE overseer NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN PASSWORD 'pefnesdy';
GRANT CONNECT ON DATABASE testgrade TO overseer;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO overseer;

GRANT INSERT ON TABLE public.logs_signin TO overseer;
GRANT UPDATE ON TABLE public.logs_signin TO overseer;
GRANT INSERT ON TABLE public.logs_signin TO overseer;
GRANT UPDATE ON TABLE public.logs_signin TO overseer;
GRANT ALL ON SEQUENCE public.seq_logs_signin TO overseer;
GRANT ALL ON SEQUENCE public.seq_logs_signin_detailed TO overseer;
GRANT ALL ON TABLE public.logs_signin_detailed TO overseer;
GRANT ALL ON TABLE public.logs_discipline_forms TO overseer;
GRANT ALL ON SEQUENCE public.seq_logs_discipline TO overseer;