Re: Grant blanket permissions on a database - Mailing list pgsql-general

From Tom Lane
Subject Re: Grant blanket permissions on a database
Date
Msg-id 3071.1007497535@sss.pgh.pa.us
Whole thread Raw
In response to Grant blanket permissions on a database  (Kirk Strauser <kirk@nmotioninc.com>)
List pgsql-general
Kirk Strauser <kirk@nmotioninc.com> writes:
> when trying to insert data into a table with a serial field.  Shouldn't the
> host line allow that user full permission to create, drop, and update every
> element in the database?

Nope.  pg_hba.conf only tells whether you are allowed to connect to a
database, not what privileges you have once you're in it.

It would appear that you need to do a little GRANTing.

            regards, tom lane

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Installing DBD::Pg module without Pg Database server
Next
From: Stephan Szabo
Date:
Subject: Re: Grant blanket permissions on a database