On Thu, Jul 8, 2010 at 8:49 AM, Niranjan Pandit <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
