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)
>
>
>
>
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 |