Thread: permissions

permissions

From
Vitaly
Date:
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?

Agri

Attachment

Re: permissions

From
Thomas Beutin
Date:
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.