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
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 |
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 |
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 |
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) |