Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Trigger Ownership

Re: Trigger Ownership

From: rr <raineyr_at_look.ca>
Date: Fri, 26 Jan 2001 20:26:00 GMT
Message-ID: <3A71F9C8.E049279D@look.ca>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US