On Thu, Jul 8, 2010 at 8:49 AM, Niranjan Pandit <smartn...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs