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