RE: setup

[Dan I. <da...@ja...>]

Perhaps you need to GRANT that user select priviliges? Soemthing like...

GRANT select ON chart TO user;

where user is the username of the postgresql user making the connection to
the db.

This can be done using the psql utility like this:


[root@host /root]# psql -d DBNAME -U postgres
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

partnership=# GRANT SELECT ON chart TO username;
CHANGE
partnership=#


You may wish to view
http://www.postgresql.org/idocs/index.php?sql-grant.html for more
information.

Hope this helps.

- Dan.


--
Dan Irwin - Systems Administrator
Jackie's Wholesale Nurseries Pty Ltd
Email: da...@ja...
Phone: 07 3888 2481
Fax: 07 3888 2530
Postal: 10 Gleeson Road Burpengary Queensland 4505
Email: in...@ja...
Web: http://www.jackies.com.au


> -----Original Message-----
> From: Peter J. Pieczora [mailto:pjp...@sy...]
> Sent: Wednesday, 16 January 2002 2:02 PM
> To: sql...@li...
> Subject: setup
> 
> 
> 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
>