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: Thu, 25 Jan 2001 04:00:54 GMT
Message-ID: <3A6FC16A.7ACAB2A0@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 Wed Jan 24 2001 - 22:00:54 CST

Original text of this message

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