Re:

Kiran,

Given that you can modify the source code for the jdbc driver you can do
practically anything you want. Although what you are suggesting would
be difficult, because in general the jdbc driver doesn't try to parse
SQL. In order to correctly do what you are trying to do on the jdbc
side you would need to implement a full SQL parser in java that mirrored
the parser on the server side in order to insert your extra where
clauses in the right places.

Security is always better implemented on the server side. You could
much more easily accomplish what you are trying to do by using server
side rules and/or views.

thanks,
--Barry

kirang(at)it(dot)iitb(dot)ac(dot)in wrote:
> hi all,
>
> I am an M.Tech Student of IITBombay, India. We are doing a project for
> Access control in Postgres.
>
> I want to know whether it is posible to modify the query given to the
> jdbc interface of the Postgres and add an extra predicate to that query.
>
> If any body could help . please reply to this mail as fast as you can.
>
> Thanks and regards.
>
> kiran
>
> KReSIT, IITB.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings