Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Accessing tables in another schema from a trigger
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