Skip to content

Instantly share code, notes, and snippets.

@juanchehin

juanchehin/SQL - chequear permiso

Created December 29, 2022 12:49
Show Gist options
  • Save juanchehin/51023c816fefd57ffceee921b6defb2b to your computer and use it in GitHub Desktop.
Save juanchehin/51023c816fefd57ffceee921b6defb2b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL - chequear permiso
-- chequear permiso
IF NOT EXISTS (SELECT IdPermiso FROM permisos_persona WHERE (IdPermiso = 1 or IdPermiso = 61) AND (IdPersona = pIdUsuario)) THEN
SELECT 'No tienes los permisos suficientes para realizar esta accion' AS Mensaje;
LEAVE SALIR;
END IF;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment