Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
usr_has_perm_at_all_nd(user_id integer, perm_code text)	FUNCTION	plpgsql	false	SETOF integer	INVOKER
grp_tree_common_ancestors(integer, integer)	FUNCTION	sql	false	SETOF permission.grp_tree	INVOKER
usr_perms(integer)	FUNCTION	sql	false	SETOF permission.usr_perm_map	INVOKER
usr_has_perm_at_nd(user_id integer, perm_code text)	FUNCTION	plpgsql	false	SETOF integer	INVOKER
grp_ancestors_distance(integer)	FUNCTION	sql	false	TABLE(id integer, distance integer)	INVOKER
usr_has_object_perm(iuser integer, tperm text, obj_type text, obj_id text, target_ou integer)	FUNCTION	plpgsql	false	boolean	INVOKER
grp_tree_full_path(integer)	FUNCTION	sql	false	SETOF permission.grp_tree	INVOKER
usr_has_work_perm(iuser integer, tperm text, target_ou integer)	FUNCTION	plpgsql	false	boolean	INVOKER
usr_has_perm_at(user_id integer, perm_code text)	FUNCTION	sql	false	SETOF integer	INVOKER
usr_has_home_perm(iuser integer, tperm text, target_ou integer)	FUNCTION	plpgsql	false	boolean	INVOKER
usr_has_perm_at_all(user_id integer, perm_code text)	FUNCTION	sql	false	SETOF integer	INVOKER
usr_can_grant_perm(iuser integer, tperm text, target_ou integer)	FUNCTION	plpgsql	false	boolean	INVOKER
grp_ancestors(integer)	FUNCTION	sql	false	SETOF permission.grp_tree	INVOKER
grp_descendants(integer)	FUNCTION	sql	false	SETOF permission.grp_tree	INVOKER
usr_has_object_perm(integer, text, text, text)	FUNCTION	sql	false	boolean	INVOKER
grp_tree_combined_ancestors(integer, integer)	FUNCTION	sql	false	SETOF permission.grp_tree	INVOKER
grp_descendants_distance(integer)	FUNCTION	sql	false	TABLE(id integer, distance integer)	INVOKER
usr_has_perm(integer, text, integer)	FUNCTION	sql	false	boolean	INVOKER