oracle8.1.6 select user_id, first_names, last_name, email, type, case when dotlrn_full_user_rels.rel_id is null then 't' else 'f' end as limited_access_p, acs_permission.permission_p(:dotlrn_package_id, user_id, 'read_private_data') as read_private_data_p, acs_permission.permission_p(acs.magic_object_id('security_context_root'), user_id, 'admin') as site_wide_admin_p from dotlrn_users, dotlrn_full_user_rels where dotlrn_users.rel_id = dotlrn_full_user_rels.rel_id(+) order by last_name