> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> Merlin Moncure
> Sent: 16 March 2005 16:04
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] prevent users from seeing pl/pgsql
> code in pgadmin
>
> 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.
Anything we did would be fairly pointless given that there's not much we
can do to stop them doing 'SELECT prosrc FROM pg_proc'. I suppose you
could remove select permissions from the table, but I wouldn't be
surprise if that broke things horribly - it certainly breaks pgAdmin and
pg_dump.
Regards, Dave.