Grant read-only permissions

Question

I want to assigned basic read-only permissions for a PostgreSQL database role that must access from an Application server like Glassfish.

Possible duplicate of [How do you create a read-only user in PostgreSQL](http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql) — mascoj, Nov 23 '16 at 17:36

score 1 · Accepted Answer · edited May 23 '17 at 12:13

1

For a production system, you can use the configuration described in this post : What GRANT USAGE ON SCHEMA exactly do?

edited May 23 '17 at 12:13

Community

answered Nov 23 '16 at 17:24

bilelovitch

1 Answers1