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
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
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
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
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