> 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.

Thanks

--
Geoff Worboys
Telesis Computing