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

Re: Functions as a Security Layer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Stookey <jamstooks(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Functions as a Security Layer
Date: 2006-01-09 03:50:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Benjamin Stookey <jamstooks(at)yahoo(dot)com> writes:
> My question is, can I somehow give permissions to the
> function, but not to the user to protect the counter
> table from being modified in any ways I don't want?

Label the function SECURITY DEFINER.

			regards, tom lane

In response to


pgsql-general by date

Next:From: Ian HardingDate: 2006-01-09 04:03:17
Subject: Re: Oracle DB Worm Code Published
Previous:From: Benjamin StookeyDate: 2006-01-09 03:43:24
Subject: Functions as a Security Layer

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