spur230 <sabinprad...@gmail.com> writes: > 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?
NEver, unless you were to revoke it from public.. Connect is granted to public by default. > 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. -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consult...@comcast.net p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
