Postgres Pro
Downloads
Home   >   mailing lists

Re: Functions as a Security Layer - Mailing list pgsql-general

From Tom Lane
Subject Re: Functions as a Security Layer
Date
Msg-id 25323.1136778646@sss.pgh.pa.us
Whole thread Raw
In response to Functions as a Security Layer  (Benjamin Stookey <jamstooks@yahoo.com>)
Responses Re: Functions as a Security Layer  (Benjamin Stookey <jamstooks@yahoo.com>)
List pgsql-general
Tree view 
Benjamin Stookey <jamstooks@yahoo.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

pgsql-general by date:

Previous
From: Benjamin Stookey
Date:
Subject: Functions as a Security Layer
Next
From: Ian Harding
Date:
Subject: Re: Oracle DB Worm Code Published