Re: How psql source code can be protected?

Re: How psql source code can be protected?

On Wed, 2010-01-06 at 13:11 -0700, Scott Marlowe wrote:
> On Wed, Jan 6, 2010 at 11:11 AM, Erik Jones  wrote:
> >
> > On Jan 6, 2010, at 8:09 AM, Marius Pitigoi wrote:
> >
> >> Hello,
> >>
> >> Is there a way to protect psql source code? For example oracle has wrap utility.
> >> I want to deploy my DB on a hosting company server. But they can see my functions code (they have root privileges) and this is what I want to avoid.
> >
> > If you don't trust your hosting company then why are you doing business with them?
> 
> This+++++
> 

Bingo...

Joshua D. Drake



-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.

Re: How psql source code can be protected?

On Wed, 2010-01-06 at 13:11 -0700, Scott Marlowe wrote:
> On Wed, Jan 6, 2010 at 11:11 AM, Erik Jones  wrote:
> >
> > On Jan 6, 2010, at 8:09 AM, Marius Pitigoi wrote:
> >
> >> Hello,
> >>
> >> Is there a way to protect psql source code? For example oracle has wrap utility.
> >> I want to deploy my DB on a hosting company server. But they can see my functions code (they have root privileges) and this is what I want to avoid.
> >
> > If you don't trust your hosting company then why are you doing business with them?
> 
> This+++++
> 

Bingo...

Joshua D. Drake



-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.

Re: How psql source code can be protected?

On Wed, Jan 06, 2010 at 05:09:06PM +0100, Marius Pitigoi wrote:
> Hello,
> 
> Is there a way to protect psql source code? For example oracle has
> wrap utility.  I want to deploy my DB on a hosting company server.
> But they can see my functions code (they have root privileges) and
> this is what I want to avoid.

The appropriate place to protect your IP is in legal agreements.

Cheers,
David.
-- 
David Fetter  http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: How psql source code can be protected?

On Jan 6, 2010, at 8:09 AM, Marius Pitigoi wrote:

> Hello,
> 
> Is there a way to protect psql source code? For example oracle has wrap utility.
> I want to deploy my DB on a hosting company server. But they can see my functions code (they have root privileges) and this is what I want to avoid. 

If you don't trust your hosting company then why are you doing business with them?

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k

Re: How psql source code can be protected?

On 06/01/2010 16:09, Marius Pitigoi wrote:
> Hello,
> 
> Is there a way to protect psql source code? For example oracle has wrap
> utility.
> I want to deploy my DB on a hosting company server. But they can see my
> functions code (they have root privileges) and this is what I want to
> avoid.

I don't think there's any way of doing this. There's been a good bit of
discussion of this topic in the past - see the archives.

In any case, since your hosting people have root privileges, there
probably isn't much you can do.... :-)

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

How psql source code can be protected?

Re: How psql source code can be protected?

On Wed, Jan 6, 2010 at 11:09 AM, Marius Pitigoi
 wrote:
> Hello,
>
> Is there a way to protect psql source code? For example oracle has wrap
> utility.
> I want to deploy my DB on a hosting company server. But they can see my
> functions code (they have root privileges) and this is what I want to avoid.

It's impossible to do this if the company has access to the database
superuser account.  If they have root access on the box there is no
real effective way from keeping them from using that account (your
main line of defense is pg_hba.conf which they can simply adjust).

If you limit them to a restricted account you can prevent casual
browsing of your procedure code by revoking select access from pg_proc
from that account and 'public'.

merlin

Re: How psql source code can be protected?

On Wed, Jan 6, 2010 at 11:11 AM, Erik Jones  wrote:
>
> On Jan 6, 2010, at 8:09 AM, Marius Pitigoi wrote:
>
>> Hello,
>>
>> Is there a way to protect psql source code? For example oracle has wrap utility.
>> I want to deploy my DB on a hosting company server. But they can see my functions code (they have root privileges) and this is what I want to avoid.
>
> If you don't trust your hosting company then why are you doing business with them?

This+++++