4 DROP FUNCTION IF EXISTS person_has_perm;
7 CREATE FUNCTION person_has_perm(
9 in_perm_name VARCHAR(64),
10 in_perm_level VARCHAR(1)
11 ) RETURNS INT(11) DETERMINISTIC
17 group_members.id INTO v_id
23 group_rights.group_id = group_members.group_id
25 group_rights.rightname= in_perm_name AND
26 accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1;