https://velog.io/@shj5508/PostgreSQL-테이블-권한-관리하기

생성

grant insert on {tablename} to {username};

수정 및 삭제 권한 추가

GRANT UPDATE, DELETE ON table_name TO username;

모든 권한 추가

GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO username;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT USAGE, SELECT ON SEQUENCES TO username;