[GENERAL] How to Prevent Certain Kinds of Joins?

2005-02-22 Thread Heather Johnson
Is there a way to revoke permission to join two or more tables, even for users who have all other permissions (e.g., select, insert, update, delete) on those tables? Heather Johnson Senior Database Programmer New York Post ---(end of broadcast

Re: [GENERAL] How to Prevent Certain Kinds of Joins?

2005-02-22 Thread Heather Johnson
an only use the views and not query the tables directly. Michael Fuhr wrote: On Tue, Feb 22, 2005 at 02:51:09PM -0500, Heather Johnson wrote: Is there a way to revoke permission to join two or more tables, even for users who have all other permissions (e.g., select, insert, update, delete) on t

Re: [ADMIN] [GENERAL] How to Prevent Certain Kinds of Joins?

2005-02-22 Thread Heather Johnson
Scott Marlowe wrote: Why not change the keys that currently connect them to something different (i.e. random noise) and make a NEW table that could join them with those random keys that is restriced access wise to only the chosen few. This might work rather nicely. It would enable us to restrict d

[GENERAL] help with plpgsql function called by trigger

2005-03-16 Thread Heather Johnson
NERATED BY SEQ FROM LAST USERS INSERT***); I'm new to writing plpgsql and to triggers, so I'm probably missing something, or doing this wrong, but I can't figure out from the docs how to send this value to the function. Can someone help point me to some doc

Re: [GENERAL] help with plpgsql function called by trigger

2005-03-17 Thread Heather Johnson
Thank you! That *is* nicer. And thanks to Michael Fuhr too for his reference to the appropriate docs and suggestions. Between your two responses, I have a much better sense of how to go about this and where to look for extra help. Heather Alban Hertroys wrote: Heather Johnson wrote: Hello-- I