Re: Get the list of permissions/privileges on schema

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: dipti shah <shahdipti1980(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Get the list of permissions/privileges on schema
Date: 2010-03-25 09:29:36
Message-ID: 8cf965d31003250229u7b4ca7b9ue4bc5f652993f25a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Thu, Mar 25, 2010 at 2:54 PM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:

> On 25 March 2010 12:14, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
> wrote:
> > You should look into the pg_class table : relacl attribute for the
> > permissions on any object.
>
> Is it correct to set it directly?
>

Of course not...
This is just way to fetch the list of permission on any object.

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company<http://www.enterprisedb.com>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dipti shah 2010-03-25 09:38:50 Re: Get the list of permissions/privileges on schema
Previous Message Sergey Konoplev 2010-03-25 09:24:46 Re: Get the list of permissions/privileges on schema

Browse pgsql-novice by date

  From Date Subject
Next Message dipti shah 2010-03-25 09:38:50 Re: Get the list of permissions/privileges on schema
Previous Message Sergey Konoplev 2010-03-25 09:24:46 Re: Get the list of permissions/privileges on schema