Help in TRIGGER [message #308206] |
Sat, 22 March 2008 01:27  |
|
Dear members , I am wasim latif , a junior dba from Bangalore.
In my oracle database 10.2.0.3.0 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  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
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.
Regards
Michel
[Updated on: Sat, 22 March 2008 01:54] Report message to a moderator
|
|
|