Skip site navigation (1) Skip section navigation (2)

Re: function body actors (was: [PERFORM] viewing source code)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: function body actors (was: [PERFORM] viewing source code)
Date: 2007-12-21 21:19:51
Message-ID: 12277.1198271991@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Andrew Sullivan <ajs(at)crankycanuck(dot)ca> writes:
> Hmm; this may be exactly part of the problem, though.  It seems there are
> two possible cases in play:

> 1.	Protect the content in the database (in this case, function bodies)
> from _all_ users on a given server.  This is a case where you want to
> protect (say) your function body from your users, because you have a
> closed-source application.  

> 2.	Protect the content of a field from _some_ users on a given system,
> based on the permissions they hold.  This is roughly analagous to others not
> being able to look in the table I created, because I haven't GRANTed them
> permission.

I would argue that (2) is reasonably well served today by setting up
separate databases for separate users.  The people who are complaining
seem to want to send out a set of functions into a hostile environment,
which is surely case (1).

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Andrew SullivanDate: 2007-12-21 21:47:46
Subject: Re: function body actors (was: [PERFORM] viewing source code)
Previous:From: Trevor TalbotDate: 2007-12-21 21:06:18
Subject: Re: viewing source code

pgsql-hackers by date

Next:From: Andrew SullivanDate: 2007-12-21 21:47:46
Subject: Re: function body actors (was: [PERFORM] viewing source code)
Previous:From: Bruce MomjianDate: 2007-12-21 21:06:15
Subject: Re: pgindent issue with EXEC_BACKEND-only typedefs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group