Received: from merlins.force9.net (merlins.force9.net [195.166.128.23]) by hub.org (8.9.3/8.9.3) with SMTP id NAA59244 for ; Tue, 15 Jun 1999 13:06:33 -0400 (EDT) (envelope-from stevew@bigeric.force9.co.uk) Received: (qmail 4497 invoked from network); 15 Jun 1999 17:10:57 -0000 Received: from mayfly.plus.net.uk (HELO mayfly.force9.net) (195.166.128.28) by merlins.force9.net with SMTP; 15 Jun 1999 17:10:57 -0000 Received: (qmail 6605 invoked from network); 15 Jun 1999 17:12:35 -0000 Received: from unknown (HELO erica) (212.56.93.32) by mayfly.plus.net.uk with SMTP; 15 Jun 1999 17:12:35 -0000 Received: by erica with MailBeamer v3.20 (WinNT 4.x Service) ; Tue, 15 Jun 1999 18:09:51 +0100 From: stevew To: "pgsql-sql@postgresql.org" Subject: Function security? Date: Tue, 15 Jun 1999 18:09:00 +0100 X-Mailer: MailBeamer v3.20 (WinNT 4.x Service) Message-ID: <172087791.961422.83@erica> X-Priority: 3 Mime-Version: 1.0 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