pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Moran <wmoran@collaborativefusion.com>
To: Roberts, Jon <Jon.Roberts@asurion.com>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: viewing source code
Date: Fri, 14 Dec 2007 11:18:49 -0500
Message-ID: <20071214111849.b8788ce4.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <1A6E6D554222284AB25ABE3229A927621129EC@nrtexcus702.int.asurion.com>
References: <1A6E6D554222284AB25ABE3229A927621129EC@nrtexcus702.int.asurion.com>

In response to "Roberts, Jon" <Jon.Roberts@asurion.com>:

> > > In an ideal world, if a user can't modify a function, he/she shouldn't
> > be
> > > able to see the source code.  If the user can execute the function, then
> > the
> > > user should be able to see the signature of the function but not the
> > body.
> > 
> > I doubt that's going to happen.  Mainly because I disagree completely
> > with your ideal world description (any user who can execute a function
> > should have the right to examine it to see what it actually does).
> 
> That is like saying anyone that has rights to call a web service should be
> able to see the source code for it.

I think that's a good idea.  If vendors were forced publish their code,
we'd have less boneheaded security breaches.

> There should be the ability to create
> some level of abstraction when appropriate.

I agree.  If vendors want to have boneheaded security breaches, they should
be allowed.

> However, in the current configuration, all users with permission to log in
> can see all source code.  They don't have rights to execute the functions
> but they can see the source code for them.  Shouldn't I be able to revoke
> both the ability to execute and the ability to see functions?

Um ... why did you snip my second paragraph where I said exactly this?

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023



view thread (60+ messages)  latest in thread

Message-ID: <20071214111849.b8788ce4.wmoran@collaborativefusion.com>
Permalink:  ../20071214111849.b8788ce4.wmoran@collaborativefusion.com/
Also on:    postgresql.org/message-id/20071214111849.b8788ce4.wmoran@collaborativefusion.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: wmoran@collaborativefusion.com, Jon.Roberts@asurion.com
  Subject: Re: viewing source code
  In-Reply-To: <20071214111849.b8788ce4.wmoran@collaborativefusion.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox