[GENERAL] Protecting stored procedures

2011-04-07 Thread Michael Gould
We want to protect the intellectual property of several of our stored procedures.  If we put them in a separate schema in the database and only allow execute on anything in that schema would that protect our stored procedures?   Best Regards     -- Michael Gould, Managing Partner Intermod

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Szymon Guz
On 7 April 2011 14:46, Michael Gould wrote: > We want to protect the intellectual property of several of our stored > procedures. If we put them in a separate schema in the database and only > allow execute on anything in that schema would that protect our stored > procedures? > > > Protect them

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Andrew Sullivan
On Thu, Apr 07, 2011 at 07:46:36AM -0500, Michael Gould wrote: > We want to protect the intellectual property of several of our stored > procedures.  If we put them in a separate schema in the database and only > allow execute on anything in that schema would that protect our stored > procedures?

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Vibhor Kumar
On Apr 7, 2011, at 6:16 PM, Michael Gould wrote: > We want to protect the intellectual property of several of our stored > procedures. If we put them in a separate schema in the database and only > allow execute on anything in that schema would that protect our stored > procedures? If use is

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Michael Gould
We wouldn't make any of the system users a superuser in Postgres and in my 20+ years experience in the industry we provide software for, the possibility of having any users of the system that are able to hack or even understand what they have if they were able to is slim. I understand that anythin

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Sim Zacks
On 04/07/2011 03:46 PM, Michael Gould wrote: We want to protect the intellectual property of several of our stored procedures. If we put them in a separate schema in the database and only allow execute on anything in that schema would that protect our stored procedures? Best Regards It dep

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread John R Pierce
On 04/07/11 7:31 AM, Michael Gould wrote: We wouldn't make any of the system users a superuser in Postgres are you providing software run on a customers box, or a turnkey managed system (hardware+software) ? anyone who has root access can easily gain database access. anyone with physical

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Andrew Sullivan
On Thu, Apr 07, 2011 at 09:31:20AM -0500, Michael Gould wrote: > We wouldn't make any of the system users a superuser in Postgres and in my > 20+ years experience in the industry we provide software for, the > possibility of having any users of the system that are able to hack or even > understand

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Joshua D. Drake
On Thu, 2011-04-07 at 12:45 -0400, Andrew Sullivan wrote: > On Thu, Apr 07, 2011 at 09:31:20AM -0500, Michael Gould wrote: > > We wouldn't make any of the system users a superuser in Postgres and in my > > 20+ years experience in the industry we provide software for, the > > possibility of having a

Re: [GENERAL] Protecting stored procedures

2011-04-07 Thread Scott Marlowe
On Thu, Apr 7, 2011 at 6:46 AM, Michael Gould wrote: > We want to protect the intellectual property of several of our stored > procedures.  If we put them in a separate schema in the database and only > allow execute on anything in that schema would that protect our stored > procedures? Just want