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

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 (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-adminpgsql-generalpgsql-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



pgsql-hackers by date

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

pgsql-admin by date

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

pgadmin-support by date

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

pgsql-general by date

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

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