Postgres Pro
Downloads
Home   >   mailing lists

How to save existing permissions on schema and later on restore it? - Mailing list pgsql-general

From dipti shah
Subject How to save existing permissions on schema and later on restore it?
Date
Msg-id d5b05a951003082226p3634ac2cw9b8697226fa5f958@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is it possible to findout actual owner of table?
Next
From: dipti shah
Date:
Subject: Re: Is it possible to findout actual owner of table?