Fredrik Olsson <[EMAIL PROTECTED]> writes: > CREATE VIEW foo AS > SELECT * FROM private.t_foo WHERE private.haveaccess(); > GRANT ALL ON foo TO public;
If the function is parameterless as you show, what is it accomplishing that could not be done with grant/revoke on the view? If it is not parameterless, you had better be more specific about what it depends on. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org