Thread: BUG #5545: permission denied on delete

BUG #5545: permission denied on delete

From
"Niranjan Pandit"
Date:
The following bug has been logged online:

Bug reference:      5545
Logged by:          Niranjan Pandit
Email address:      smartnp81@gmail.com
PostgreSQL version: 8.4
Operating system:   Fedora 13
Description:        permission denied on delete
Details:

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 ?

Re: BUG #5545: permission denied on delete

From
Robert Haas
Date:
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