Re: Setting Permissions for web viewing
От
D. Duccini
Тема
Re: Setting Permissions for web viewing
Дата
Msg-id
Pine.GSO.4.03.10010191229130.20213-100000@ra.bpsi.net
Ответ на
Setting Permissions for web viewing (Kevin Leclaire)
Список
Дерево обсуждения
Re: data dictionary? Beth Gatewood <bethg@mbt.washington.edu>
Re: data dictionary? Tom Lane <tgl@sss.pgh.pa.us>
changing data type Chris <csmith@squiz.net>
Re: changing data type "D. Duccini" <duccini@backpack.com>
changing datestyle Thomas Good <tomg@q8.nrnet.org>
Re: changing datestyle Jason Davis <jdavis@tassie.net.au>
Re: changing datestyle Thomas Good <tomg@q8.nrnet.org>
Re: changing data type <bmccoy@chapelperilous.net>
Re: changing data type "D. Duccini" <duccini@backpack.com>
Re: changing data type <bmccoy@chapelperilous.net>
Re: changing data type "D. Duccini" <duccini@backpack.com>
Re: changing data type <bmccoy@chapelperilous.net>
Setting Permissions for web viewing "Kevin Leclaire" <kevin@virtualnav.com>
Re: Setting Permissions for web viewing "D. Duccini" <duccini@backpack.com>
RE: Setting Permissions for web viewing "k" <kraznus@yahoo.com>
RE: Setting Permissions for web viewing Chris <csmith@squiz.net>
Re: changing data type Thomas Good <tomg@q8.nrnet.org>
Re: data dictionary? "D. Duccini" <duccini@backpack.com>
the problem isn't the database, its the user the webserver is running as you can solve this by using chown and chmod u+s to make the script execute as a known user to the database the alernate is to pass in a fully qualified connect string specifying user/database -duck On Thu, 19 Oct 2000, Kevin Leclaire wrote: > 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 > ----------------------------------------------------------------------------- david@backpack.com BackPack Software, Inc. www.backpack.com +1 651.645.7550 voice "Life is an Adventure. +1 651.645.9798 fax Don't forget your BackPack!" -----------------------------------------------------------------------------
В списке pgsql-novice по дате отправления
