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

From Benjamin Stookey
Subject Re: Functions as a Security Layer
Date
Msg-id 20060109041831.42619.qmail@web35007.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Functions as a Security Layer  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks so much. That did the trick!

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>




__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com


pgsql-general by date:

Previous
From: Shelby Cain
Date:
Subject: Re: Functions as a Security Layer
Next
From: Assad Jarrahian
Date:
Subject: userdefined types