Received: from merlins.force9.net (merlins.force9.net [195.166.128.23]) by hub.org (8.9.3/8.9.3) with SMTP id IAA09912 for ; Tue, 15 Jun 1999 08:35:12 -0400 (EDT) (envelope-from stevew@bigeric.force9.co.uk) Received: (qmail 14960 invoked from network); 15 Jun 1999 12:39:26 -0000 Received: from mayfly.plus.net.uk (HELO mayfly.force9.net) (195.166.128.28) by merlins.force9.net with SMTP; 15 Jun 1999 12:39:26 -0000 Received: (qmail 27536 invoked from network); 15 Jun 1999 12:25:47 -0000 Received: from 95.usr05.shef.dialup.force9.net (HELO bigeric.force9.co.uk) (195.166.134.95) by mayfly.plus.net.uk with SMTP; 15 Jun 1999 12:25:47 -0000 Sender: stevew Message-ID: <376642FC.4C01738E@bigeric.force9.co.uk> Date: Tue, 15 Jun 1999 13:11:40 +0100 From: Steve Waterworth Organization: Just Me X-Mailer: Mozilla 4.03 [en] (X11; U; SunOS 5.5.1 sun4m) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: help with function security Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I wish to control access to some tables, so I do not want to grant select to all users. Instead I would like to use some functions which return the info. So I have some tables owned by admin I have a user who does not have select permission on the tables owned by admin. admin has created some functions which perform some selects on admin's tables. When user runs these functions, user gets permission denied. Is there a way to let the user be admin when running the functions ???? You can do this with Oracle. Any help appreciated Regards, Steve