Re: How Do I Hide Trigger ?? - Mailing list pgsql-sql

From Christoph Haller
Subject Re: How Do I Hide Trigger ??
Date
Msg-id 200304140916.LAA09389@rodos
Whole thread Raw
In response to How Do I Hide Trigger ??  ("Yudha Setiawan" <inas_husband@BonBon.net>)
List pgsql-sql
> 
> 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 



pgsql-sql by date:

Previous
From: "Yudha Setiawan"
Date:
Subject: How Do I Hide Trigger ??
Next
From: Rado Petrik
Date:
Subject: REPLACE