| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Paul Mackay <mackaypaul(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Utility of GRANT EXECUTE |
| Date: | 2006-03-14 16:23:34 |
| Message-ID: | 20060314162334.GA985@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Mar 14, 2006 at 09:57:54AM +0100, Paul Mackay wrote:
> Is there a way to change the default prvilege on functions, i.e. that like
> for tables, only the creator has privilege on it by default ?
Not that I'm aware of. You could revoke USAGE on the functions'
schema so attempts to call the functions would fail with "permission
denied for schema" but that might be too sweeping a solution. The
idea of having default privileges has come up before; the developers'
TODO list has an item that mentions "GRANT SELECT ON NEW TABLES."
Is there a particular problem you're trying to solve?
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jojo Paderes | 2006-03-14 17:06:29 | Re: Clustered PostgreSQL |
| Previous Message | Guy Fraser | 2006-03-14 16:21:49 | Re: Wisconsin Circuit Court Access (WCCA) on PostgreSQL |