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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | CaT | 2006-02-27 12:22:50 | Re: Priviliges and Roles |
Previous Message | Dayo Johnson | 2006-02-27 12:09:48 | Priviliges and Roles |