second_user.sql

-- DROP ROLE "tamaro-skaljic_chat";

CREATE ROLE "tamaro-skaljic_chat" WITH
    NOSUPERUSER
    NOCREATEDB
    NOCREATEROLE
    NOINHERIT
    LOGIN
    NOREPLICATION
    NOBYPASSRLS;

--
-- Name: TABLE chat_message; Type: ACL; Schema: public; Owner: tamaro-skaljic
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.chat_message TO "tamaro-skaljic_chat";

--
-- Name: TABLE "user"; Type: ACL; Schema: public; Owner: tamaro-skaljic
--

GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public."user" TO "tamaro-skaljic_chat";