Re: [GENERAL] Hide the code from users postgres

2016-03-25 Thread Michael Milligan
He asked a legitimate question. Why he wants to hide the code is his business. If you don't know the answer, or don't want to tell him, don't answer. Michael Milligan

Re: [GENERAL] Hide the code from users postgres

2010-06-25 Thread akp geek
Thank you all for the responses. I got a requirement from my boss that I need to give read only access to only tables , so that users can write some queries. At that time, he also mentioned that the users should not see the code. I read the document , but not able to figure out how to do that and t

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
On Thu, Jun 24, 2010 at 10:59 PM, Allan Kamau wrote: > Perhaps (I could be wrong here), there may be a way (even though I > don't really support the obfuscation, vendor lockup etc... idea). > 1)Use a commercial DB (as mentioned previously), they seem to have > provided for this. > 2)Use PostgreSQ

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Allan Kamau
On Fri, Jun 25, 2010 at 12:28 AM, Dave Page wrote: > On Thu, Jun 24, 2010 at 10:20 PM, Joshua D. Drake > wrote: >> On Thu, 2010-06-24 at 22:18 +0100, Dave Page wrote: >> >>> > I have no problem with him trying to protect his hard earned work. I >>> > just think he is trying to solve the wrong pr

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
On Thu, Jun 24, 2010 at 10:20 PM, Joshua D. Drake wrote: > On Thu, 2010-06-24 at 22:18 +0100, Dave Page wrote: > >> > I have no problem with him trying to protect his hard earned work. I >> > just think he is trying to solve the wrong problem. >> >> It's a real problem faced by many businesses an

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Pavel Stehule
2010/6/24 Joshua D. Drake : > On Thu, 2010-06-24 at 22:18 +0100, Dave Page wrote: > >> > I have no problem with him trying to protect his hard earned work. I >> > just think he is trying to solve the wrong problem. >> >> It's a real problem faced by many businesses and solved by most >> commercial

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Pavel Stehule
2010/6/24 akp geek : > It's not for the user postgres.. If I have created a testuser, can I hide > the code for that testuser? > Regards > you can do it. But mostly of all instruments for postgres will not work corectly - like pgAdmin and others. So this step is usually unwanted. try REVOKE SELE

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Joshua D. Drake
On Thu, 2010-06-24 at 22:18 +0100, Dave Page wrote: > > I have no problem with him trying to protect his hard earned work. I > > just think he is trying to solve the wrong problem. > > It's a real problem faced by many businesses and solved by most > commercial DBMSs. Of course, it's basically im

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Dave Page
On Thu, Jun 24, 2010 at 10:08 PM, Joshua D. Drake wrote: > On Fri, 2010-06-25 at 00:00 +0300, Allan Kamau wrote: > >> >> Seems akp would like to hide/protect (including his name) his hard >> earned code/IP which may have consumed some man-hours, which to run, >> requires well built and generously

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Raymond O'Donnell
On 24/06/2010 22:00, Allan Kamau wrote: > Seems akp would like to hide/protect (including his name) his hard > earned code/IP which may have consumed some man-hours, which to run, > requires well built and generously given PostgreSQL code which has > taken man-decades to develop. There's been quit

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Joshua D. Drake
On Fri, 2010-06-25 at 00:00 +0300, Allan Kamau wrote: > > Seems akp would like to hide/protect (including his name) his hard > earned code/IP which may have consumed some man-hours, which to run, > requires well built and generously given PostgreSQL code which has > taken man-decades to develop.

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Allan Kamau
On Thu, Jun 24, 2010 at 11:11 PM, Joshua D. Drake wrote: > On Thu, 2010-06-24 at 16:06 -0400, akp geek wrote: >> It's not for the user postgres.. If I have created a testuser, can I >> hide the code for that testuser? > > No. Of course you have to wonder, "why" you would do that. It is the > data

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Joshua D. Drake
On Thu, 2010-06-24 at 16:06 -0400, akp geek wrote: > It's not for the user postgres.. If I have created a testuser, can I > hide the code for that testuser? No. Of course you have to wonder, "why" you would do that. It is the data you are protecting, not the code to retrieve the data. Just make su

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread akp geek
It's not for the user postgres.. If I have created a testuser, can I hide the code for that testuser? Regards On Thu, Jun 24, 2010 at 3:42 PM, Pavel Stehule wrote: > Hello > > 2010/6/24 akp geek : > > Hi all - > > Is there way in postgres to set the user privileges so that > when > > t

Re: [GENERAL] Hide the code from users postgres

2010-06-24 Thread Pavel Stehule
Hello 2010/6/24 akp geek : > Hi all - >           Is there way in postgres to set the user privileges so that when > they login , the user can not see functions and views? you can't do it for user postgres. Regards Pavel Stehule > Regards -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Hide the code from users postgres

2010-06-24 Thread akp geek
Hi all - Is there way in postgres to set the user privileges so that when they login , the user can not see functions and views? Regards