Received: from hotmail.com (f154.law9.hotmail.com [64.4.9.154]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9IHEpP94184 for ; Thu, 18 Oct 2001 13:14:51 -0400 (EDT) (envelope-from skumar7777@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 18 Oct 2001 10:14:50 -0700 Received: from 203.124.229.229 by lw9fd.law9.hotmail.msn.com with HTTP; Thu, 18 Oct 2001 17:14:50 GMT X-Originating-IP: [203.124.229.229] From: "Sushil Kumar" To: pgsql-sql@postgresql.org Cc: sushil.kumar@tatainfotech.com Subject: Privileges on Functions in Postgres 7.1.3 Date: Thu, 18 Oct 2001 22:44:50 +0530 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 18 Oct 2001 17:14:50.0504 (UTC) FILETIME=[653C4880:01C157F8] X-Archive-Number: 200110/277 X-Sequence-Number: 5230 Hi, Is it possible to allow a user to execute a procedure that will update some tables without the user having any privileges on the underlying tables themselves (like in Oracle where the procedure effectively runs with the privilege of the creator)? Regards, _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp