Re: Grant blanket permissions on a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kirk Strauser <kirk(at)nmotioninc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Grant blanket permissions on a database
Date: 2001-12-04 20:25:35
Message-ID: 3071.1007497535@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kirk Strauser <kirk(at)nmotioninc(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-12-04 20:43:26 Re: Grant blanket permissions on a database
Previous Message Kirk Strauser 2001-12-04 20:03:27 Grant blanket permissions on a database