Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger question
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
![]() |
![]() |