From: | frbn <frbn(at)efbs-seafrigo(dot)fr> |
---|---|
To: | Barker <barkerds(at)snybufaf(dot)buffalostate(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Warning: PostgreSQL query failed: ERROR: [my_tabel]: |
Date: | 2002-08-09 13:11:07 |
Message-ID: | 3D53BF6B.5080902@efbs-seafrigo.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Barker a écrit:
> Yes, the webserver is apache, and read/write permission is granted
> as seen below.
>
> The example below shows that the permission-denied problem happens
> in the Unix mode too for the apache user, but not for the postgres
> superuser.
>
> --------------------------------------------------------
> [root(at)linux5 octave]# psql --version
> psql (PostgreSQL) 7.2.1
> ...
>
> [root(at)linux5 octave]# psql -U apache octave
> Welcome to psql, the PostgreSQL interactive terminal.
> ...
>
> octave=> \z
> Access privileges for database "octave"
> Table | Access privileges
> -------+--------------------------------
> form | {=,postgres=arwdRxt,apache=rw}
> use | {=,postgres=arwdRxt,apache=rw}
> (2 rows)
>
> octave=> INSERT INTO use VALUES ('date', 'time', 'ip', 'port', 'Mozilla'
> );
> ERROR: use: Permission denied.
apache needs to have the "a"ppend privilege on the table "use"
nd: "w"rite privilege is for updates/deletes
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2002-08-09 13:31:01 | Re: UNIQUE constraint matching given keys for referenced |
Previous Message | Jarosław Nozderko | 2002-08-09 13:05:26 | Stored procedures returning rowsets |