From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: about privileges on pg_stat_activity columns |
Date: | 2008-12-04 13:54:35 |
Message-ID: | 3073cc9b0812040554p22118f55g725fee61d432475d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 4, 2008 at 4:02 AM, Richard Huxton <dev(at)archonet(dot)com> wrote:
> Jaime Casanova wrote:
>>
>> we created an user to him and give him privileges to pg_locks and
>> pg_stat_activity (and the functions pg_stat_activity is calling) but
>> still he see the columns that comes from the functions as null... is
>> there a way to give him access to that data without give him
>> superuser?
>
> I'd create a view or some functions with "security definer" privileges.
> That way you can provide precisely the access needed.
>
exactly what i did... thanks to both
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
From | Date | Subject | |
---|---|---|---|
Next Message | paulo matadr | 2008-12-04 13:55:00 | pg_stat_activity |
Previous Message | Serge Fonville | 2008-12-04 13:45:50 | Re: serial |