From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | akp geek <akpgeek(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Hide the code from users postgres |
Date: | 2010-06-24 21:20:55 |
Message-ID: | AANLkTimkdTSbR64I6FZ0qi0uvw57biOsBS6uz8S5d6i3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2010/6/24 akp geek <akpgeek(at)gmail(dot)com>:
> It's not for the user postgres.. If I have created a testuser, can I hide
> the code for that testuser?
> Regards
>
you can do it. But mostly of all instruments for postgres will not
work corectly - like pgAdmin and others. So this step is usually
unwanted.
try
REVOKE SELECT ON pg_proc FROM public;
REVOKE SELECT ON pg_view FROM public;
> On Thu, Jun 24, 2010 at 3:42 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>>
>> Hello
>>
>> 2010/6/24 akp geek <akpgeek(at)gmail(dot)com>:
>> > Hi all -
>> > Is there way in postgres to set the user privileges so that
>> > when
>> > they login , the user can not see functions and views?
>>
>> you can't do it for user postgres.
>>
>> Regards
>>
>> Pavel Stehule
>>
>> > Regards
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2010-06-24 21:20:58 | Re: Hide the code from users postgres |
Previous Message | Dave Page | 2010-06-24 21:18:24 | Re: Hide the code from users postgres |