How to save existing permissions on schema and later on restore it?

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: How to save existing permissions on schema and later on restore it?
Date: 2010-03-09 06:26:56
Message-ID: d5b05a951003082226p3634ac2cw9b8697226fa5f958@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi,

Could anyone please suggest me how to save the existing permissions on
schema and later on restore it? Basically, by default I have revoked all the
permissions from the mydb schema but there are some users who has all
permissions on mydb schema. I have one stored procedure which temporary
grant the ALL permissions on mydb schema and later on revoke it and just
grant USAGE permissions. Here I have problem if users have full permissions
on schema executes the stored procedure. His original schema permissions
will be altered by my stored procedure. I want to prevent this.

Thanks,
Dipti

Browse pgsql-general by date

  From Date Subject
Next Message dipti shah 2010-03-09 06:29:36 Re: Is it possible to findout actual owner of table?
Previous Message Tom Lane 2010-03-09 06:24:32 Re: Is it possible to findout actual owner of table?

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Smith 2010-03-09 07:15:32 Re: [NOVICE] How to read oracle table's data from postgre
Previous Message Joyce Gerald-LGJ002 2010-03-08 21:30:52 'database cluster initialization failed' in Linux