Re: Who is the owner?? Who executes??

From: AndrewV <andrew.velichko_at_moh.gov.on.ca>
Date: 30 Jan 2002 10:16:47 -0800
Message-ID: <335c961b.0201301016.21912370@posting.google.com>

Hi!

Won't be any error in your scenario if the second user has grant insert on table 'A' and no priviledges at all on table 'B'. Trigger will be executed
by the first user and table 'B' will be populated from that trigger without problems.

Regards,

Andrew Velichko
Brainbench MVP for Oracle Developer 2000 http://www.brainbench.com

miotromailcarlos_at_netscape.net (Carlos) wrote in message news:<1de5ebe7.0201300802.561c85c0_at_posting.google.com>...
> If one user creates a trigger on a table 'A' he owns (i.e: an after
> insert trigger that inserts rows in other table 'B' of the same
> schema) and other user tries to insert a row in the 'A' table but he
> has not pivileges to write on this 'B' table, will be an error? Who
> 'executes' the trigger, the user who created it or the user who is
> intending to insert a row in the 'A' table?
Received on Wed Jan 30 2002 - 12:16:47 CST