Skip site navigation (1) Skip section navigation (2)

Re: prevent users from seeing pl/pgsql code in

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: prevent users from seeing pl/pgsql code in
Date: 2005-03-16 16:59:13
Message-ID: 423865E1.60406@pse-consulting.de (view raw or flat)
Thread:
Lists: 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 
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 ;-)

Regards,
Andreas

In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2005-03-16 17:05:38
Subject: Re: prevent users from seeing pl/pgsql code in pgadmin
Previous:From: Merlin MoncureDate: 2005-03-16 16:54:09
Subject: Re: prevent users from seeing pl/pgsql code in pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group