Index: lams_build/conf/unix/authentication/lamsauthentication.xml =================================================================== RCS file: /usr/local/cvsroot/lams_build/conf/unix/authentication/Attic/lamsauthentication.xml,v diff -u -r1.2.2.1 -r1.2.2.2 --- lams_build/conf/unix/authentication/lamsauthentication.xml 7 Jun 2007 01:28:01 -0000 1.2.2.1 +++ lams_build/conf/unix/authentication/lamsauthentication.xml 10 Jul 2007 07:50:44 -0000 1.2.2.2 @@ -52,6 +52,18 @@ + + java:/jdbc/lams-ds + select password from lams_user where login=? + + SELECT DISTINCT r.name,'Roles' FROM + lams_user u LEFT OUTER JOIN lams_user_organisation uo USING(user_id) + LEFT OUTER JOIN lams_user_organisation_role urr USING(user_organisation_id) + LEFT OUTER JOIN lams_role r USING (role_id) + WHERE u.login=? + + + ldap://mams.melcoe.mq.edu.au:636