spur230 <sabinpradhan@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.consulting@comcast.net
p: 312.241.7800