No, absolutely not. Principal of minimal privileged. Users don't need to be able to drop the database, delete all tables, change settings, backup, restore and hence they should not have enough permissions to do that.

Regarding your permissions problems, check the ownership of the tables and the procedures (not schema, owner), see if they are different. If they are, then the ownership chaining mentioned earlier won't work and hence the users will be having permission denied errors.