X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/840abcc48a16d1149da9922585135f09a41e789a..84f76d573967832523dfc728235a56f2b2e14dba:/lib/SAMURAI/Usuario/consultas.ini?ds=sidebyside

diff --git a/lib/SAMURAI/Usuario/consultas.ini b/lib/SAMURAI/Usuario/consultas.ini
index c21cc12..7ee89a5 100644
--- a/lib/SAMURAI/Usuario/consultas.ini
+++ b/lib/SAMURAI/Usuario/consultas.ini
@@ -15,3 +15,4 @@ borrar                 = " DELETE FROM samurai.perfil_sist_usuario WHERE login =
 
 obtener_informacion = "  SELECT psu.login AS login, psu.id_sistema AS id_sistema, sist.nombre_sistema AS nombre_sistema, psu.id_perfil AS id_perfil, perf.desc_perfil AS desc_perfil, pps.id_permiso AS id_permiso, perm.desc_permiso AS desc_permiso, pps.observaciones AS observaciones FROM samurai.permiso AS perm, samurai.perfil AS perf, samurai.sistema AS sist, samurai.perfil_sist_usuario AS psu, samurai.perm_perfil_sist AS pps WHERE psu.id_perfil = pps.id_perfil AND  psu.id_sistema = pps.id_sistema AND psu.id_sistema = sist.id_sistema AND  psu.id_perfil = perf.id_perfil AND pps.id_permiso = perm.id_permiso AND  psu.login = ? ORDER BY sist.nombre_sistema, perf.desc_perfil, perm.desc_permiso"
 
+obtener_datos_compartido = "SELECT DISTINCT psu.login AS login, u.nombre AS nombre FROM samurai.perfil_sist_usuario AS psu, usuario.Usuario as u WHERE psu.login LIKE '%##?##%' AND psu.login = u.login ORDER BY psu.login"