Separating function privileges from tables - Mailing list pgsql-general

From Barry Brown
Subject Separating function privileges from tables
Date
Msg-id 22F5B117-D733-4A16-A537-E5AF8E7BA238@cs.sierracollege.edu
Whole thread Raw
Responses Re: Separating function privileges from tables
List pgsql-general
Hi all,

It's nice that privileges on views are separate from the privileges
on its underlying tables. For example, if view V queries tables A and
B, I only need to grant SELECT on the view to another user; tables A
and B can have that privilege revoked and the view works.

Are there plans to extend similar behavior to functions? That is, can
I simply grant EXECUTE on the function and not have to worry about
granting the appropriate privileges to the tables used by the function?

Thanks.

-B

pgsql-general by date:

Previous
From: William Garrison
Date:
Subject: Help tracking down error in postgres log
Next
From: Lew
Date:
Subject: Re: Temporal Units