Re: setup

[Sergio A. K. <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
...

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
>
>