Re: [GENERAL] grant connect on database

2015-12-16 Thread Adrian Klaver
On 12/16/2015 11:58 AM, Jerry Sievers wrote: spur230 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

Re: [GENERAL] grant connect on database

2015-12-16 Thread Jerry Sievers
spur230 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 dat

[GENERAL] grant connect on database

2015-12-16 Thread spur230
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 conne