Is there any simple way to define read only roles. Basically that user should be able to login and be able to do *select* statements alone. It should be applied for all tables in all schemas in a database. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin