Re: Get the list of permissions/privileges on schema - Mailing list pgsql-general

From John R Pierce
Subject Re: Get the list of permissions/privileges on schema
Date
Msg-id 4BABE23E.8040806@hogranch.com
Whole thread Raw
In response to Re: Get the list of permissions/privileges on schema  (dipti shah <shahdipti1980@gmail.com>)
Responses Re: Get the list of permissions/privileges on schema  (dipti shah <shahdipti1980@gmail.com>)
List pgsql-general
dipti shah wrote:
> Thanks a lot guys but I am not looking for security definer function.
> I know it. My requirements are very complicated and I have to nailed
> down the stuffs by storing schema permissions somewhere, execute my
> store procedure, and restored the stored schema permissions. Like this
> I would make sure that thogh my store procedure manipulates schema
> permissions, at the end, users will have their permissions intact.
>

thats totally the wrong way to do things in SQL.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performing FETCH ALL from a SCROLL CURSOR failing to return results
Next
From: Geoffrey Gowey
Date:
Subject: Geoffrey Gowey wants to stay in touch on LinkedIn