If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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…

Options

04-04-2007 4: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