Hi,
Our database (8.2.6) runs on a separate machine from the web interface. Each user has their own username/password and row level security is handled by a set of views on top of the base tables.
I'd like to provide programatic access to my database (I have been looking at Perl's DBIx::Class), but I want to control which tables/ views can be queried via this route. I thought of creating a second database with views wrapping dblink queries to the main database. The problem is that the dblink query needs to send a password even after the user has been authenticated against the first. Is there a way to get this to work or to get around this?
Maybe on a more general note i wonder if those with more experience than me knows, does this approach sound like complete madness or are there better ways to approach this?
thanks for any help Adam -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general