Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA63797 for ; Tue, 15 Jun 1999 13:35:31 -0400 (EDT) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id MAA27438; Tue, 15 Jun 1999 12:35:19 -0500 (CDT) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma027363; Tue, 15 Jun 99 12:35:05 -0500 Received: by cpsmail with Internet Mail Service (5.5.2448.0) id ; Tue, 15 Jun 1999 12:34:56 -0500 Message-ID: From: "Jackson, DeJuan" To: stevew , "pgsql-sql@postgresql.org" Subject: RE: [SQL] Function security? Date: Tue, 15 Jun 1999 12:34:56 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain You should be able to accomplish this with views. Check out the docs on views and the rewrite system. -DEJ > -----Original Message----- > From: stevew [SMTP:stevew@bigeric.force9.co.uk] > Sent: Tuesday, June 15, 1999 12:09 PM > To: pgsql-sql@postgresql.org > Subject: [SQL] Function security? > > 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