On Thu, Jul 8, 2010 at 8:49 AM, Niranjan Pandit <smartnp81@gmail.com> wrote:
> role A is member of role B, role B has delete privilege also the select
> privilege on the id field of the table. when logged in with role A and set
> role to B, the permission is still denied to delete a record, any ideas why
> is permission denied ?
>
> the set role is in a security invoker function before the delete statement.
> Could this be related in anyway ?
I tried it here and it worked for me. Can you provide a
self-contained test case?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company