Re: Trigger Ownership

From: Ken Brown <ken.brown_at_dialwrap.com>
Date: Thu, 25 Jan 2001 13:11:12 -0000
Message-ID: <94p8go$o8d$1@neptunium.btinternet.com>

Yes, I should have been clearer on what I want.

I'm using schema logon triggers for users controlled through forms. User A runs the form and creates user B. Part of the create process is to create the AFTER LOGON B.schema Trigger. this trigger is owned by user A though as he created.

What I want is for User A to move ownership of this trigger to User B.

Reason. If user A is deleted then all their objects will cascade i.e. user B's trigger will disappear.

"rr" <raineyr_at_look.ca> wrote in message news:3A6FC16A.7ACAB2A0_at_look.ca...
> It is possible for oracle 8 procedures to be executed taking on the schema
of
> the user who runs the procedure.
> rachel
>
> Ken Brown wrote:
>
> > Can the ownership of a trigger be changed without connecting as that
user to
> > create the trigger.
> >
> > In particular I want to use the AFTER LOGON trigger against a schema but
I
> > want the SCHEMA to own it's own trigger.
> >
> > If so how?
>
Received on Thu Jan 25 2001 - 07:11:12 CST