Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: E.KarystinakisDate: 2006-02-27 16:07:12
Subject: Database information
Previous:From: Lane Van IngenDate: 2006-02-27 13:31:45
Subject: Re: pgStatTuple

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group