Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Who is the owner?? Who executes??

Who is the owner?? Who executes??

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 30 Jan 2002 08:02:05 -0800
Message-ID: <1de5ebe7.0201300802.561c85c0@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 - 10:02:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US