Hi

grant the drop table privelege to user A .Then it will work.

regards
Hrishy