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 -> Accessing tables in another schema from a trigger

Accessing tables in another schema from a trigger

From: Bo Brunsgaard <bbcworldtour_at_hotmail.com>
Date: 2 Apr 2004 00:20:58 -0800
Message-ID: <55c7f17e.0404020020.4e8fbbd@posting.google.com>


Hi group,

Purely a matter of curiosity:

To save hassle and administration we generally only grant access through roles. However, in some rare cases we need a trigger to be able to access tables in another schema, which will only work if access to the tables is granted explicitly to the user, and not through a role (we're on 9.1 on Windows XP, if that matters).

While it does mess up our setup of privileges a little bit, it is rare enough for me to live with (anyway, it's hardly worth dying over :-) I had another case of it yesterday and that rekindled my curiosity, so I wonder: does anyone here know the reasons and rationale behind this?

Thanks in advance

Bo Brunsgaard
Vitus Bering, Denmark Received on Fri Apr 02 2004 - 02:20:58 CST

Original text of this message

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