Re: prevent users from seeing pl/pgsql code in pgadmin - Mailing list pgadmin-hackers

From Merlin Moncure
Subject Re: prevent users from seeing pl/pgsql code in pgadmin
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A764F@Herge.rcsinc.local
Whole thread Raw
In response to prevent users from seeing pl/pgsql code in pgadmin  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgadmin-hackers
> Merlin Moncure wrote:
> > Is there any relatively easy way to, uh, prevent your users from
seeing
> > some/all of your pl/pgsql code in pgAdmin? :)  A by schema solution
> > would be ideal.
>
> I could think of an additional option for schema names that should be
> treated as system schema (like the Slony-I and pgAgent schema), but

That sounds interesting, how would that be accomplished?

> there's no solution to prevent reengineering that's not done on the
> server side. And coding sophisticated algorithms in plpgsql is for
> masochists only anyway ;-)

hmm!  I must be a masochist then!  I've busily converting our erp server
code from cobol to pl/pgsql atm.  The performance of pl/pgsql is just
amazing...I haven't worked with the other pl languages much (save sql),
but I wonder what else would meet my requirements.

Merlin

pgadmin-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: prevent users from seeing pl/pgsql code in pgadmin
Next
From: "Hiroshi Saito"
Date:
Subject: Re: Again, the requirement of password of dlgUser.cpp