Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Trigger Ownership
HI Ken,
I thought you might be referring to definer vs. invoker rights -- new to Oracle
8. Anyway, that may be able to help you with some things too, if you're not
already doing so.
If user b dissaprears, so do all its objects. This is good. Not if user b is a
programmer, developing all the programming objects under his schema. Once
programmer objects are tested, they should be created under a different user, so
they outlive the programmer. They may also at times want to have invoker rights,
though in the case of the procedure which creates a user and a corresponding
trigger, definer rights would make sense, and it would also make sense that the
trigger exist within the programmer objects schema.
I hope this helps,
Rachel Rainey
Ken Brown wrote:
> 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 Fri Jan 26 2001 - 14:26:00 CST
![]() |
![]() |