authen.public

Parameters

Name	Type	Mode
prop_id	integer	IN
user_id	integer	IN
category_id	text	IN (DEFAULT NULL)
code	character	OUT
name	text	OUT
category	text	OUT
subcategory	text	OUT
parent	character	OUT
is_granted	boolean	OUT

Definition

DECLARE
  v_prop_id ALIAS FOR prop_id;
  v_user_id ALIAS FOR user_id;
  v_group_id int;
  v_group_type char(1);
begin
  SELECT g.id, g.group_type
  FROM users u LEFT JOIN user_group g ON g.id = u.user_group_id
  WHERE u.id = v_user_id
  INTO v_group_id, v_group_type;
  
  RETURN QUERY
  SELECT p.code, p.name, p.category, p.subcategory, p.parent, u.code is not null
  FROM fn_get_permission_codes(category_id) p LEFT JOIN user_permission u
        on p.code = u.code and u.prop_id = v_prop_id and u.user_id = v_user_id
  WHERE category_id is null or p.code like category_id||'%'
  order by code;  

/*-- USE GROUP PERMISSION FOR SYSTEM USER (supports, developers, etc.)
  IF (v_group_type = 'S') THEN
      RETURN QUERY
      SELECT p.code, p.name, p.category, p.subcategory, p.parent, g.code is not null
      FROM fn_get_permission_codes(category_id) p LEFT JOIN group_permission g
            on p.code = g.code and g.group_id = v_group_id
      WHERE category_id is null or p.code like category_id||'%'
     order by code;
  ELSE
      RETURN QUERY
      SELECT p.code, p.name, p.category, p.subcategory, p.parent, u.code is not null
      FROM fn_get_permission_codes(category_id) p LEFT JOIN user_permission u
            on p.code = u.code and u.prop_id = v_prop_id and u.user_id = v_user_id
      WHERE category_id is null or p.code like category_id||'%'
      order by code;
  END IF;*/
END

fn_get_user_permissions

Description

Parameters

Definition