oracle8.1.6 select dotlrn_users.*, case when dotlrn_full_user_profile_rels.rel_id is null then 'Limited' else 'Full' end as access_level, acs_permission.permission_p(:dotlrn_package_id, :user_id, 'read_private_data') as read_private_data_p from dotlrn_users, dotlrn_full_user_profile_rels where dotlrn_users.user_id = :user_id and dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id(+) select cr_items.live_revision as revision_id, nvl(cr_revisions.title, 'view this portrait') portrait_title from acs_rels, cr_items, cr_revisions where acs_rels.object_id_two = cr_items.item_id and cr_items.live_revision = cr_revisions.revision_id and acs_rels.object_id_one = :user_id and acs_rels.rel_type = 'user_portrait_rel' select dotlrn_class_instances_full.*, dotlrn_member_rels_approved.role, acs_permission.permission_p(dotlrn_class_instances_full.class_instance_id, :user_id, 'admin') as admin_p from dotlrn_class_instances_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_class_instances_full.class_instance_id order by dotlrn_class_instances_full.department_name, dotlrn_class_instances_full.department_key, dotlrn_class_instances_full.pretty_name, dotlrn_class_instances_full.community_key select dotlrn_clubs_full.*, dotlrn_member_rels_approved.role, acs_permission.permission_p(dotlrn_clubs_full.club_id, :user_id, 'admin') as admin_p from dotlrn_clubs_full, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_clubs_full.club_id order by dotlrn_clubs_full.pretty_name, dotlrn_clubs_full.community_key select dotlrn_communities.*, dotlrn_community.url(dotlrn_communities.community_id) as url, dotlrn_member_rels_approved.role, acs_permission.permission_p(dotlrn_communities.community_id, :user_id, 'admin') as admin_p from dotlrn_communities, dotlrn_member_rels_approved where dotlrn_member_rels_approved.user_id = :user_id and dotlrn_member_rels_approved.community_id = dotlrn_communities.community_id and dotlrn_communities.community_type = 'dotlrn_community' order by dotlrn_communities.pretty_name, dotlrn_communities.community_key