feature suggestion and return to pgsql-general :-) - Mailing list pgsql-general

From Dennis Gearon
Subject feature suggestion and return to pgsql-general :-)
Date
Msg-id 632529.70966.qm@web82107.mail.mud.yahoo.com
Whole thread Raw
Responses Re: feature suggestion and return to pgsql-general :-)
List pgsql-general
Hi guys, I am back after a long time of doing other kinds of work. Don't know if anybody remembers me - not a biggee.

I am again working on a design of a web application for myself. Security seems MUCH more of an issue, EVERY day.

So I had these to suggestions/feature requests.

To prevent SQL injection, have either permissions-per-role, or DB wide, or DB instance configurable with defalaults and
override configuration, blah blah, the following. 

A flag/permission to allow ONLY prepared queries
A flag/permission to allow ONLY UDF/procedures.

These may be mutually exclusive?

But a way to set a database to absolutely be strongly sql injection proof.

Comments?

Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life

I agree with Bolivian President Evo Morales

# The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings."

# The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything."

# The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals and
treeshave rights." 

# The right to harmony and balance between everyone and everything: "We are all interdependent."


See the movie - 'Inconvenient Truth'
See the movie - 'Syriana'

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: need help for PostgreSQL consistency check mechanism
Next
From: Dhaval Shah
Date:
Subject: Question regarding pam_pgsql [looking for a BSD License pam_pgsql]