Skip to content
Snippets Groups Projects
Normal view History Permalink
nopatch_create_overseer.sql 728 B
Newer Older
Anton Bagliy's avatar
ADD: script to create read-only user that can auth #327
Anton Bagliy committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
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;