su - projop
psql
select authority_id from auth_authorities;
update users set authority_id = ##### where username = 'USERNAME';

where ##### the authority_id from the select query and USERNAME the username from the user is.