Privs useful to any new user created.
create user "<user>" password '<PWD>';
GRANT USAGE ON SCHEMA <SCHEMA> TO <user>;
GRANT SELECT,UPDATE,INSERT,DELETE ON ALL TABLES IN SCHEMA <SCHEMA> TO <user>;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA <SCHEMA> TO <user>;
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA <SCHEMA> TO <user>;