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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger question

Re: Trigger question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Mar 2000 20:06:32 +0200
Message-ID: <954353668.2363.0.pluto.d4ee154e@news.demon.nl>


Which errors?
Personally however, I would strongly advise against doing that. You'r getting a maze in which you easily will get lost.

Regards,
Sybrand Bakker, Oracle DBA

Svein Fossdal <sveifo_at_frisurf.no> wrote in message news:gqrE4.27011$6b1.496726_at_news1.online.no...
> Hello
>
> Does anybody know if it takes special priveliges
> to create a trigger on a table in another shema than the current?
>
> I have a trigger that compiles fine as long as it is created
> upon an action towards a table in the current shema.
>
> Creating the very same trigger as another user ("...ON shema.table ...")
> , however, will only compile with errors.
>
> I have "create trigger" privelege for all users.
>
> Any ideas?
>
>
>
Received on Wed Mar 29 2000 - 12:06:32 CST

Original text of this message

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