Index: openacs-4/packages/dotlrn/www/admin/user-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user-oracle.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/dotlrn/www/admin/user-oracle.xql 29 Mar 2002 19:38:26 -0000 1.6 +++ openacs-4/packages/dotlrn/www/admin/user-oracle.xql 28 Apr 2002 04:08:42 -0000 1.7 @@ -6,12 +6,9 @@ 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 + from dotlrn_users where dotlrn_users.user_id = :user_id - and dotlrn_users.rel_id = dotlrn_full_user_profile_rels.rel_id(+)