[GENERAL] Oracle's Virtual Private Database functionality

2005-03-13 Thread Doug Bloebaum
In the spirit of tell us what you're trying to do... I'd like to mimic a subset of Oracle's Virtual Private Database functionality (see http://dba-oracle.com/oracle_news/2004_1_16_vpd_security.htm for an overview) in Postgres: based on some per-connection setting, I'd like a query to return a

Re: [GENERAL] Oracle's Virtual Private Database functionality

2005-03-13 Thread Bruno Wolff III
On Wed, Mar 09, 2005 at 13:52:28 -0500, Doug Bloebaum [EMAIL PROTECTED] wrote: It's apparent why: the view determines which table it's going to use at view creation time, not at query time, so this method is no good. Is there a right way to accomplish what I'm trying to do? I think the

Re: [GENERAL] Oracle's Virtual Private Database functionality

2005-03-11 Thread Qingqing Zhou
Check out CREATE RULE command, Regards, Qingqing Doug Bloebaum [EMAIL PROTECTED] дÈëÓʼþ news:[EMAIL PROTECTED] [ Sorry if this appears twice on the list: sent it via a non-subscribed email the first time around. Of course, while waiting for it to appear I figured out a workaround; see the