Setting Permissions for web viewing - Mailing list pgsql-novice

From Kevin Leclaire
Subject Setting Permissions for web viewing
Date
Msg-id NCBBKIKAKKEDELCFBBBDIEEEEBAA.kevin@virtualnav.com
Whole thread Raw
In response to Re: changing data type  (<bmccoy@chapelperilous.net>)
Responses Re: Setting Permissions for web viewing  ("D. Duccini" <duccini@backpack.com>)
List pgsql-novice
What's the cleanest way to set permissions in postgres so that a web
application can properly view and query a back-end database, but not modify?

I have tried modifying pg_hba.conf, and got it to do a pg_connect()
successfully, however, the subsequent pg_Exex() call failed with the
following browser error: "Warning: PostgreSQL query failed: ERROR:
table_name: Permission denied..."

Thanks!

Kevin


pgsql-novice by date:

Previous
From:
Date:
Subject: Re: changing data type
Next
From: Tom Lane
Date:
Subject: Re: Stupid question: concatenating strings