CREATE USER username PASSWORD 'pwd';

GRANT SELECT, INSERT, UPDATE, DELETE, TRIGGER ON ALL TABLES IN SCHEMA public TO username;
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO username;