[SQL] Securing VIEWS that use contrib/pgcrypto -- how?

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

Re: [SQL] Securing VIEWS that use contrib/pgcrypto -- how?

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 unregister