Re: permissions - Mailing list pgsql-general

From Thomas Beutin
Subject Re: permissions
Date
Msg-id 20030219095130.B22753@laokoon.bug.net
Whole thread Raw
In response to permissions  (Vitaly <agri@desnol.ru>)
List pgsql-general
On Wed, Feb 19, 2003 at 11:25:33AM +0300, Vitaly wrote:
> Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: groups_id_seq.nextval: you don't have permissions to set
sequencegroups_id_seq . in /usr/var/web/owl/phplib/db_pgsql.inc on line 67 
> Database error: Invalid SQL: INSERT INTO groups (name) VALUES ('desnol')
> PostgreSQL Error: 1 (ERROR: groups_id_seq.nextval: you don't have permissions to set sequence groups_id_seq )
> Session halted.
>
> Please help... what should i do to permit this operation?
GRANT ALL ON "groups_id_seq" TO <user>;

<user> must be the database user who is connected to the database.

-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Table Partitioning in Postgres:
Next
From: Teodor Sigaev
Date:
Subject: Re: problems with tsearch