X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4B374475A80
	for <pgsql-sql@postgresql.org>; Mon, 14 Apr 2003 05:16:16 -0400 (EDT)
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id BC4A24760E3
	for <pgsql-sql@postgresql.org>; Mon, 14 Apr 2003 05:15:44 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Mon Apr 14 11:16:14 2003 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id LAA15149; Mon, 14 Apr 2003 11:16:14 +0200 (METDST)
From: Christoph Haller <ch@rodos.fzk.de>
Message-Id: <200304140916.LAA09389@rodos>
Subject: Re: How Do I Hide Trigger ??
To: inas_husband@BonBon.net (Yudha Setiawan)
Date: Mon, 14 Apr 2003 11:16:13 METDST
Cc: pgsql-sql@postgresql.org
In-Reply-To: <00d901c30236$6b4920b0$ea00a8c0@yudha>;
	from "Yudha Setiawan" at Apr 14, 103 5:33 am
X-Mailer: Elm [revision: 212.4]
X-Spam-Status: No, hits=-9.1 required=5.0
	tests=BAYES_10,INVALID_DATE,IN_REP_TO,QUOTE_TWICE_1
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/202
X-Sequence-Number: 12903

> 
> Dear Milist,=20
> For the security reason, i'd like=20
> to Hide or Encrypting some Function,
> triggers or procedure on tables pg_proc,=20
> So If I have many user on my database,
> there will be one user could see the
> "prosrc" on pg_proc or could do select=20
> the pg_proc without encrypted.
> 
> Any advice will be helpfull.
> 
Would this help? 

revoke all privileges on pg_proc from public;

Regards, Christoph