Re: grant connect on database

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