you have created a procedure DELETETABLE which uses dynamic sql to our remove a table in your schema. you have granted the EXECUTE privilege to a user X on this procedure
when user X executes the procedure under whose privilege are the operation performed bydefault
1.yours
2.user X