Re: functions and grants question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Avi Schwartz <avi(at)CFFtechnologies(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: functions and grants question
Date: 2003-05-22 02:28:46
Message-ID: 13627.1053570526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Avi Schwartz <avi(at)CFFtechnologies(dot)com> writes:
> In other databases, stored procedures run under the privilege of the
> stored procedure owner. Is it supposed to work the same in postgresql?

Only if you attach the SECURITY DEFINER option to the function.

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2003-05-22 07:11:51 Re: Postgresql ODBC driver for OS X?
Previous Message Rick Gregory 2003-05-22 00:56:55 unsubscribe