Thanks so much. That did the trick!
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Benjamin Stookey <[EMAIL PROTECTED]> 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
> wan
--- Benjamin Stookey <[EMAIL PROTECTED]> wrote:
> Functions, with some databases, are used as security
> layers so that a user that wouldn't otherwise have
> read/write privileges on a table can perform some sort
> of controlled update.
>
> I've written a function to serve as a type of counter
Benjamin Stookey <[EMAIL PROTECTED]> 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
---
