Jim,
Once again, your solution has worked wonders for me. I can now call the
Function via the DELETE RULE. Thank you very much. You rock!
By the way, as you may have noticed, I could not find ANY online
documentation on using PGCrypto + VIEWS + RULES + FUNCTIONs, all combined;
nor does the "pur
On Fri, Mar 25, 2005 at 07:53:46AM -0800, Moran.Michael wrote:
> Anyway, by far, this Posgres SQL forum is the best forum I've encountered
> for finding answers to questions like mine below. Much better than the
> Hackers or Admin forums it seems.
Some subjects are off-topic for some mailing list
Hello there,
How do you secure a VIEW so that only certain users may use it?
Let's say you have a table that has a BYTEA column that holds (pgcrypto)
encrypted data; and you have a VIEW on the aforementioned table that returns
the decrypted contents of the BYTEA column.
How do you secure this V
"Moran.Michael" <[EMAIL PROTECTED]> writes:
> How do you secure a VIEW so that only certain users may use it?
GRANT/REVOKE?
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregis