Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Securing PostgreSQL

Zombrex · 2007-04-04 15:54:19

Hi guys, I'm trying to set up PostgreSQL 7.4 so that a client application can only execute specific procedures rather than having privileges to execute ad hoc SELECT statements on tables in a database. I can't figure out if this is possible, and the offical documentation doesn't help. It seems to be that if you want a…

04-04-2007 04:54PM

#1

Zombrex

Closed Accounts Posts: 25,848 ✭✭✭✭

Join Date: March 2001

Posts: 25665

Hi guys,

I'm trying to set up PostgreSQL 7.4 so that a client application can only execute specific procedures rather than having privileges to execute ad hoc SELECT statements on tables in a database.

I can't figure out if this is possible, and the offical documentation doesn't help. It seems to be that if you want a client to be able to run a function that SELECTs data from a table the client must be given GRANT SELECT on that table, and therefore the client can run any select query it wants on the database.

Any help would be appreciated

0