Create a trigger before drop a table on oracle 11g
703787Sep 18 2011 — edited Sep 18 2011Hi all,
I am working on oracle 10g database.
My requirement is i want to revoke drop table(Only table) from owner(He is a original owner he owned the table).
The owner can able to create a table and other objects .
But we won't allow to drop a table. he can drop other objects like procudure,packages..
So i decide to implement the above solution with trigger.
Can anyone please guide me ,if possible please post the sample code.
regards,
reshu