Open the database>Users and delete bob from the database and then re-add the login.  Be sure to note what permissions bob has before you delete him!!