How to avoid users from viewing functions code

From: cad0022(at)iperbole(dot)bologna(dot)it
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, pgadmin-hackers(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org
Subject: How to avoid users from viewing functions code
Date: 2003-10-03 11:09:31
Message-ID: 1065179371.3f7d58eb8abb9@webmail.iperbole.bologna.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin pgsql-general pgsql-hackers

Hi
the problem is to avoid users from viewing functions code (in general db
structures) when connecting to db by means of pgpadmin client.
My db contains several tables and functions and I need to make users viewing
only a restricted
number of tables. It works for tables, as it's possible to define access
policies,
but I didn't find something like that for functions.
The result is that everyone can see functions code from all pgadmin (II & III)
clients using basic user account.

This is my PostgreSQL Client Authentication Configuration File

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 10.43.13.75 255.255.255.255 trust
host template1 basic 0.0.0.0 0.0.0.0 md5
host servizio basic 0.0.0.0 0.0.0.0 md5

Is there any idea?

Thanks Paolo Mattioli

Browse pgadmin-support by date

  From Date Subject
Next Message Adam H. Pendleton 2003-10-03 12:22:48 Re: [pgadmin-support] Bug in pgadmin III displaying/exporting dat
Previous Message Andreas Pflug 2003-10-03 10:24:09 Re: Bug in pgadmin III displaying/exporting dat

Browse pgsql-admin by date

  From Date Subject
Next Message Rob Long 2003-10-03 13:20:28 Re: pg_restore fails - postgres 7.3.4
Previous Message Jarek Lubczyński 2003-10-03 10:57:06 Re: initdb error on windows - urgent, please

Browse pgsql-general by date

  From Date Subject
Next Message Peter Childs 2003-10-03 11:13:29 Re: Type of application that use PostgreSQL
Previous Message Marc Cuypers 2003-10-03 10:42:16 administration with pgaccess

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2003-10-03 11:37:07 Re: count(*) slow on large tables
Previous Message Michael Meskes 2003-10-03 10:59:19 Re: ecpg doesn't compile (datetime.h/dtime_t)