Re: How Do I Hide Trigger ??

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How Do I Hide Trigger ??
Date: 2003-04-14 14:30:27
Message-ID: 3E9AC603.5030401@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)postgresql(dot)org)
>
>
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Franco Bruno Borghesi 2003-04-14 15:20:02 Re: REPLACE
Previous Message Rado Petrik 2003-04-14 13:09:43 REPLACE