Re: Obfuscated stored procedures (was Re: Oracle and Postgresql) - Mailing list pgsql-general

From Glyn Astill
Subject Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Date
Msg-id 21405.44191.qm@web25808.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
List pgsql-general
> Because it's so full of obvious loopholes.  Yes,
> it might slow down
> > someone who didn't have superuser access to the
> database or root access
> > to the machine it's on; but that doesn't count
> as secure really.  The
> > problem is that the people who ask for this type of
> feature are usually
> > imagining that they can put their code on
> customer-controlled machines
> > and it will be safe from the customer's eyes.
> Well, it isn't, and
> > I don't think Postgres should encourage them to
> think it is.
>

As much as I'm impressed with the "we do it properly or not at all" attitude, it'd be nice if there was an option to
stopthe casual user from viewing code. 

I'll admit to obfusicating bits and pieces using C, even though the function and everything it acts on are tied down
withpermissions. I understand in reality it provides no real extra security but somehow users being able to easily view
somethingthey don't have access to execute beyond it's name just feels wrong. 




pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Index order
Next
From: Glyn Astill
Date:
Subject: Re: Index order