Bruce Momjian <[EMAIL PROTECTED]> writes: > Someone asked me a question about view and function permissions. I > assumed all object access done by a view would be based on the > permissions on the view, and not the permissions of the objects.
Table references are checked according to the owner of the view, but use in a view does not change the execution context for function or operator calls. This is how it's always been done. > Is this a bug? Changing it would be a major definitional change (and a pretty major implementation change too). It might be better, but please don't pre-judge the issue by labeling it a bug. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly