Require superuser status for adding triggers

patch by Aleksey Yeschenko; reviewed by Jonathan Ellis for
CASSANDRA-5963