Geoff,

> > Packages is like Pascal units. [...]
> > For your issue with triggers you could create package with
> > private variable and public get\set procedures. Grant access
> > on set-procedure for user callable procedures and grant
> > access on get-procedure for triggers.
>
> Hmmm... if this is possible then it may well be able to solve
> my problem.
>
> I dont think it is as elegant as executing a procedure with a
> specific role (which would also help to simplify the granting
> of procedure permissions), but it does sound like a workable
> solution.

As I see it, what Vlad has proposed is exactly what you need.

You want an otherwise hidden variable which are visible to triggers, so
that the operation of the triggers can vary depending on the
variable(s).


Sean