Re: Priviliges and Roles - Mailing list pgsql-admin

From Dayo Johnson
Subject Re: Priviliges and Roles
Date
Msg-id 4403013D.7000402@cleanjohn.net
Whole thread Raw
In response to Priviliges and Roles  (Dayo Johnson <dayoj@cleanjohn.net>)
List pgsql-admin
Jerry Sievers wrote:
> Dayo Johnson <dayoj@cleanjohn.net> writes:
>
>
>> Is it possible to do the following:
>> Disallow permission to write to a table (either by UPDATE or INSERT) but
>> allow EXECUTE permission on a Function that writes to the table ?
>>
>
> Study up on the 'security definer' option in the manual sections on
> user defined functions.
>
> HTH
>
Thank you, I believe that sorts me out  :-)

Cheers DayoJ


pgsql-admin by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: Re: pgStatTuple
Next
From: Bruno Wolff III
Date:
Subject: Re: Priviliges and Roles