Index: openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql	29 Mar 2002 19:38:26 -0000	1.6
+++ openacs-4/packages/dotlrn/www/admin/user-edit-oracle.xql	28 Apr 2002 04:08:42 -0000	1.7
@@ -10,12 +10,10 @@
                    dotlrn_users.last_name,
                    dotlrn_users.email,
                    dotlrn_users.type,
-                   case when dotlrn_full_user_profile_rels.rel_id is null then 'limited' else 'full' end as access_level,
+                   dotlrn_users.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(+)
         </querytext>
   </fullquery>