X-Git-Url: https://git.llucax.com/mecon/samurai.git/blobdiff_plain/22d1ae1aa6bfee6df20dfa9544e14feaecc9fbf4..35dc97263ea8ab3af79406a00b8896e55c93d9b3:/lib/SAMURAI/Perfil/consultas.ini?ds=sidebyside diff --git a/lib/SAMURAI/Perfil/consultas.ini b/lib/SAMURAI/Perfil/consultas.ini index 7a3dda6..fba4c77 100644 --- a/lib/SAMURAI/Perfil/consultas.ini +++ b/lib/SAMURAI/Perfil/consultas.ini @@ -7,6 +7,7 @@ obtener_datos_perfil3 = " WHERE p.desc_perfil = ?" obtener_id_perfiles = " SELECT ps.id_perfil FROM samurai.perfil_sist as ps, samurai.perfil as p WHERE ps.id_perfil = p.id_perfil " obtener_id_perfiles3 = " AND ps.id_sistema = ? " obtener_id_perfiles2 = " AND p.desc_perfil like '%##FILTRO##%'" +obtener_id_perfiles4 = " ORDER BY p.desc_perfil" borrar_perfil = " DELETE FROM samurai.perfil as p " obtener_permisos = " SELECT id_permiso, observaciones FROM samurai.perm_perfil_sist WHERE id_perfil = ? AND id_sistema = ?"