I am using Postgres 9.4. I created a login role and gave select to all tables to a schema as follows: create role fix; create role dcv login password 'mypassword' in role fix; grant select on all tables on schema xzy to dcv'; I was able to connect to the database without giving 'grant connect on database db1 to dcv' My question is when do I have to explicitly give connect grant? How did user dcv connect to database without the connect privilege? Thanks -- View this message in context: http://postgresql.nabble.com/grant-connect-on-database-tp5877872.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
