Re: Priviliges and Roles

From: Dayo Johnson <dayoj(at)cleanjohn(dot)net>
To: Jerry Sievers <jerry(at)jerrysievers(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Priviliges and Roles
Date: 2006-02-27 13:40:13
Message-ID: 4403013D.7000402@cleanjohn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jerry Sievers wrote:
> Dayo Johnson <dayoj(at)cleanjohn(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message E.Karystinakis 2006-02-27 16:07:12 Database information
Previous Message Lane Van Ingen 2006-02-27 13:31:45 Re: pgStatTuple