Re: grant connect on database

spur230 <sabinpradhan(at)gmail(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800