On Sun, Jul 24, 2011 at 2:46 PM, Kurt Buff <kurt.buff@xxxxxxxxx> wrote: > On Sun, Jul 24, 2011 at 14:36, Mario Puntin <mariomop@xxxxxxxxx> wrote: >> >> Hi everybody: >> I searched the web trying to find an answer to this, but found none. I have >> a postgresql server and a database, and I granted access to some users. >> However I want them to access the data only through some specific client >> application. I do not want them to have access through psql or some other >> kind of client app. But, as I created them a user/pass they could use them. >> What would you do? >> Thanks in advance. > > Make a web front end, and present them with only the queries you want > them to have, via a dropdown list and a set of fields for which you > sanitize the input. > > Alternatively, build a GUI app that does the same thing, but if your > users are sophisticated and/or malicious you'll also have to build the > GUI with some sort of application authentication and encryption. Don't mean to butt in, but how does this meet Mario's requirement of blocking access from psql and/or only allowing access from a specific client? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
