From: Guy Fraser <guy@incentre.net>
To: pgsql-sql@postgresql.org
Subject: Re: How Do I Hide Trigger ??
Date: Mon, 14 Apr 2003 08:30:27 -0600
Message-ID: <3E9AC603.5030401@incentre.net> (raw)
References: <200304140916.LAA09389@rodos>
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)
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guy@incentre.net
Subject: Re: How Do I Hide Trigger ??
In-Reply-To: <3E9AC603.5030401@incentre.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox