From: | Kirk Strauser <kirk(at)nmotioninc(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Grant blanket permissions on a database |
Date: | 2001-12-04 20:03:27 |
Message-ID: | 87snaq92i8.fsf@legion.priv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am using PostgreSQL-7.1.2_2 on a FreeBSD 4.4-STABLE server. I am running
Apache on the same machine, and have a PHP website that connects to the
PostgreSQL server on localhost. I want the user that the website connects
as to have full permission to do anything it wants on that particular
database, so it seemed like it would be reasonable to add to my pg_hba.conf:
host mydatabase 127.0.0.1 255.255.255.255 crypt
This works, in general. However, I always get errors similar to:
Warning: PostgreSQL query failed: ERROR: sysusers_usersys_seq.nextval: you
don't have permissions to set sequence sysusers_usersys_seq
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?
--
Kirk Strauser
Internet Software Engineer
NMotion, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-04 20:25:35 | Re: Grant blanket permissions on a database |
Previous Message | Vivek Khera | 2001-12-04 20:02:21 | Re: Installing DBD::Pg module without Pg Database server |