Re: setup

[Sergio A. K. <ser...@ho...>]

----- Original Message -----
From: "Sergio A. Kessler" <ser...@ho...>


> iif 'apache' is the user under your web server run on:
>
> - login into your DB as postgres user
> - psql sql-ledger
> - grant all an apache to table1
> - grant all an apache to table1

duh!
"grant all on table to user"

> ...
>
> or
>
> indicate that the user connect as 'postgres' user
>
> /sergio
>
> ----- Original Message -----
> From: "Peter J. Pieczora" <pjp...@sy...>
>
>
> > Hi,
> >
> > I got it all up and running but when trying to setup accoutnts I get
> > following error
> > Error!
> >
> > SELECT accno,
> > SUM(acc_trans.amount) AS amount
> > FROM chart, acc_trans
> > WHERE chart.id = acc_trans.chart_id
> > GROUP BY accno
> > ERROR: chart: Permission denied.
> >
> > So, I guess, I have, or rather user under which webserver is running
have
> no
> > right permissions to access DB. Anyway I wonder how to get around it?
> >
> > Cheers,
> >
> > Peter
> >
> >
>
>