functions and grants question - Mailing list pgsql-odbc

From Avi Schwartz
Subject functions and grants question
Date
Msg-id 9215DB99-8BDC-11D7-9862-000393AE5044@CFFtechnologies.com
Whole thread Raw
Responses Re: functions and grants question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
In other databases, stored procedures run under the privilege of the
stored procedure owner.  Is it supposed to work the same in postgresql?

I am the owner of the database, tables and functions.  When I grant
execute permission on a function to another user, that user gets
permission denied errors on the tables the stored procedure is
accessing.  Any idea what I may be doing wrong?

Thanks,
Avi
--
Avi Schwartz
avi@CFFtechnologies.com


pgsql-odbc by date:

Previous
From: Avi Schwartz
Date:
Subject: Postgresql ODBC driver for OS X?
Next
From: "Rick Gregory"
Date:
Subject: unsubscribe