Re: How to prevent deletes when DELETE ANY TABLE granted?

Gert Rijs wrote:
>
> Hi John,
> just a thought (not tested):
> - create a package with a boolean variable in its header called
> 'delete_allowed'
> - in your after insert-update-delete trigger set it to true
> - in your 'replica' trigger check the delete_allowed variable (instead of
> username).
> hope this helps..
> Gert

Gert,

This was an excellent idea and worked well. Thanks for your help!

-- 
John Verbil
U S WEST Communications
Information Technologies
jverbil_at_uswest.com
(303) 896-0916