Message-ID: <3E9AC603.5030401@incentre.net>
Date: Mon, 14 Apr 2003 08:30:27 -0600
From: Guy Fraser <guy@incentre.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: How Do I Hide Trigger ??
References: <200304140916.LAA09389@rodos>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I have not quite figured out schemas yet, but ...
{Now that really *is* on open ended question:-}

Christoph Haller wrote:

>>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 
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>  
>