| From: | Benjamin Stookey <jamstooks(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Functions as a Security Layer |
| Date: | 2006-01-09 04:18:31 |
| Message-ID: | 20060109041831.42619.qmail@web35007.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks so much. That did the trick!
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
> ---------------------------(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Assad Jarrahian | 2006-01-09 06:21:16 | userdefined types |
| Previous Message | Shelby Cain | 2006-01-09 04:03:47 | Re: Functions as a Security Layer |