Re: functions and grants question - Mailing list pgsql-odbc

From Tom Lane
Subject Re: functions and grants question
Date
Msg-id 13627.1053570526@sss.pgh.pa.us
Whole thread Raw
In response to functions and grants question  (Avi Schwartz <avi@CFFtechnologies.com>)
List pgsql-odbc
Avi Schwartz <avi@CFFtechnologies.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

pgsql-odbc by date:

Previous
From: "Rick Gregory"
Date:
Subject: unsubscribe
Next
From: "Dave Page"
Date:
Subject: Re: Postgresql ODBC driver for OS X?