The following bug has been logged online: Bug reference: 5545 Logged by: Niranjan Pandit Email address: smartn...@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 ? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs