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

Re: Get the list of permissions/privileges on schema

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(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:24:46
Message-ID: c3a7de1f1003250224q79368a2as57c8d1d0719dfa79@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
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?

> On Thu, Mar 25, 2010 at 2:37 PM, dipti shah <shahdipti1980(at)gmail(dot)com> wrote:
>> Could any one please tell me how to get list of all the permissions on the
>> schema (or any postgresql objects), stored them somewhere before executing
>> stored procedure and then restore them?

May be you are looking for something like SECURITY DEFINER option?
http://www.postgresql.org/docs/8.4/interactive/sql-createfunction.html

-- 
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802

In response to

Responses

pgsql-novice by date

Next:From: Ashesh VashiDate: 2010-03-25 09:29:36
Subject: Re: Get the list of permissions/privileges on schema
Previous:From: Ashesh VashiDate: 2010-03-25 09:14:48
Subject: Re: Get the list of permissions/privileges on schema

pgsql-general by date

Next:From: Ashesh VashiDate: 2010-03-25 09:29:36
Subject: Re: Get the list of permissions/privileges on schema
Previous:From: Ashesh VashiDate: 2010-03-25 09:14:48
Subject: Re: Get the list of permissions/privileges on schema

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