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

Re: Priviliges and Roles

From: "Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk>
To: dayoj(at)cleanjohn(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Priviliges and Roles
Date: 2006-02-27 12:21:51
Message-ID: ivcicf.enc6d9@webmail2.mailnetwork.co.uk (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Dayo,

This is how I understand it, but I might be wrong:
I believe the user who is has permission to execute the function also needs
permissions to perform the table writes.

Regards

Andy

Dayo Johnson  wrote:

> Hello,
> 
> 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 ?
> 
> The reason I want to do this is so that I can perform certain checks on 
> the data that is being written before I allow it to be written.
> 
> Cheers DayoJ
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 
> !DSPAM:14,4402ee2c160447970214199!
> 
> 
> 

_________________________________________________________
This mail sent using V-webmail - http://www.v-webmail.org

In response to

pgsql-admin by date

Next:From: CaTDate: 2006-02-27 12:22:50
Subject: Re: Priviliges and Roles
Previous:From: Dayo JohnsonDate: 2006-02-27 12:09:48
Subject: Priviliges and Roles

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