Skip site navigation (1) Skip section navigation (2)

Re: Get the list of permissions/privileges on schema

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: Sergey Konoplev <gray(dot)ru(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:38:50
Message-ID: d5b05a951003250238r1a2463d2tb8a73e37deb7ca6b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Thanks a lot guys but I am not looking for security definer function. I know
it. My requirements are very complicated and I have to nailed down the
stuffs by storing schema permissions somewhere, execute my store procedure,
and restored the stored schema permissions. Like this I would make sure that
thogh my store procedure manipulates schema permissions, at the end, users
will have their permissions intact.

Thanks,
Dipti

On Thu, Mar 25, 2010 at 2:59 PM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:

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

pgsql-novice by date

Next:From: Ɓukasz DejnekaDate: 2010-03-25 11:23:33
Subject: Using HStore type in TSearch
Previous:From: Ashesh VashiDate: 2010-03-25 09:29:36
Subject: Re: Get the list of permissions/privileges on schema

pgsql-general by date

Next:From: Andre LopesDate: 2010-03-25 10:25:52
Subject: What datatype should I use to store an IP Address?
Previous:From: Ashesh VashiDate: 2010-03-25 09:29:36
Subject: Re: Get the list of permissions/privileges on schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group