Separating function privileges from tables

From: Barry Brown <barry(at)cs(dot)sierracollege(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Separating function privileges from tables
Date: 2007-05-03 04:41:21
Message-ID: 22F5B117-D733-4A16-A537-E5AF8E7BA238@cs.sierracollege.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-03 04:59:40 Re: pgsql and Mac OS X
Previous Message Naz Gassiep 2007-05-03 04:36:08 Re: Update violating constraint