prevent drop of table

[sukimac]

I've been advised that we could use an before drop on database trigger (8i and > only) something like

tkyte@ORACLE8I> create or replace trigger ddl_trigger
2 before create or alter or drop on DATABASE
3 begin
4 if ( user in ( 'SCOTT', 'HOTEL', 'PEOPLE' ) )
5 then
6 raise_application_error( -20001,
'You are not allowed to DROP' );
7 end if;
8 end;
9 /

but I don't to enforce this across the whole database only a specific schema. Any thoughts?