jeff81 wrote:who are "they"?
Yes I thought about doing it that way. It is much simpler. Data Vault is confusing. But they
don't want the DBA to modify this code.what code is it "they" don't want you ("the DBA") to modify? It sounds like "they" don't understand how things are structured and who is responsible for what.
So I either have to do it all in Data Vault or I do it in the logon trigger and then put a realm around that trigger. I would prefer not to use the trigger method because then I would be able to freely control that trigger if I want to add other logon things. I guess I could create a second logon trigger but that is messy.