oracle8.1.6
select dotlrn_users.id,
dotlrn_users.type,
dotlrn_user_types.pretty_name as pretty_type,
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,
dotlrn_user_types
where dotlrn_users.user_id = :user_id
and dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id(+)
and dotlrn_users.type = dotlrn_user_types.type
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