Re: How Do I Hide Trigger ??

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: inas_husband(at)BonBon(dot)net (Yudha Setiawan)
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How Do I Hide Trigger ??
Date: 2003-04-14 11:16:13
Message-ID: 200304140916.LAA09389@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Radovan Petrikí 2003-04-14 12:50:52 REPLACE
Previous Message Yudha Setiawan 2003-04-14 01:36:48 How Do I Hide Trigger ??