added role in user table and modified code accordingly