| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashesh Vashi | 2010-03-25 09:29:36 | Re: Get the list of permissions/privileges on schema |
| Previous Message | Ashesh Vashi | 2010-03-25 09:14:48 | Re: Get the list of permissions/privileges on schema |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashesh Vashi | 2010-03-25 09:29:36 | Re: Get the list of permissions/privileges on schema |
| Previous Message | Ashesh Vashi | 2010-03-25 09:14:48 | Re: Get the list of permissions/privileges on schema |