select pretty_name, authority_id from auth_authorities where enabled_p = 't' and auth_impl_id is not null order by sort_order