Re: views and triggers

From: sybrandb <sybrandb_at_gmail.com>
Date: 12 Sep 2006 04:32:07 -0700
Message-ID: <1158060727.079704.87800@m73g2000cwd.googlegroups.com>

schw wrote:
> is it possible to create a trigger on view as not being sysdba user?

According to the documentation, you can only create instead of triggers on views.
Please read up on object privileges in the documentation and don't post such utter nonsense here.
Also creating triggers as non-object owner is an extreemly bad idea.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Tue Sep 12 2006 - 06:32:07 CDT