Utility of GRANT EXECUTE

From: "Paul Mackay" <mackaypaul(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Utility of GRANT EXECUTE
Date: 2006-03-14 08:24:52
Message-ID: 786c2f6d0603140024l16824e6dm6cf37f2ca0570ca5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems that any user has the right to execute a function, whether or not
it has been granted the EXECUTE privilege on it. Even a REVOKE EXECUTE has
no impact. A privilige error will be raised only if the function tries to
access an object (ex.: a table) for witch the user doesn't have the
appropriate privilege(s).

Is there any utility to the GRANT EXECUTE then ?

Thanks,
Paul

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-03-14 08:40:28 Re: Utility of GRANT EXECUTE
Previous Message Simon Riggs 2006-03-14 08:08:53 Re: [pgsql-advocacy] Wisconsin Circuit Court Access (WCCA) on