You have to grant 'create table' permission to db user or put user in db_ddladmin db role.