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: (view raw, whole thread or download thread mbox)
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.
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-2017 The PostgreSQL Global Development Group