alter role <username> set search_path = <schema1>, ..., <scheman>, public;