Home » SQL & PL/SQL » SQL & PL/SQL » Help in TRIGGER (ORACLE, 10G , Windows 2000)
Help in TRIGGER [message #308206] Sat, 22 March 2008 01:27 Go to next message
Messages: 2
Registered: March 2008
Location: Bangalore
Junior Member

Dear members , I am wasim latif , a junior dba from Bangalore.

In my oracle database i wanted to enable a trigger which will stop
three users from performing DDL statements . When i enabled the trigger ,
the users who try to drop any table gets the message "Illegal Operation, DDL Not

Allowed. Please Contact the DBA" . And even after i disable the trigger , the users
are not able to perform DDL and get the message "TABLE OR VIEW DOESN'T EXIT" .
Even if he tries to SELECT or DESCRIBE the table "TABLE OR VIEW DOESN'T EXIT"

message is shown . The table is there in the user tables but cannot be retrieved with

the SELECT statement from then on . What might be the problem

The TRIGGER script is attached
Re: Help in TRIGGER [message #308209 is a reply to message #308206] Sat, 22 March 2008 01:53 Go to previous message
Michel Cadot
Messages: 65152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not come from your trigger which is disable, maybe another one or maybe the table really does not exist.

You have to copy and paste your user session, before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.


[Updated on: Sat, 22 March 2008 01:54]

Report message to a moderator

Previous Topic: ANSI join statements
Next Topic: Disadvantages of many kinds
Goto Forum:

Current Time: Tue Aug 22 02:26:27 CDT 2017

Total time taken to generate the page: 0.04260 seconds