Comment by alFReD-NSH

Don't give them the DROP permission and have them go through a (automated) process to elevate their privilege when they need it.