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