authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_check_permission
Parameters
Name
Type
Mode
user_name
text
IN
prop_id
integer
IN
code
character
IN
Definition
begin return coalesce(( with A as ( select u.id as user_id from user_property p inner join users u on u.id = p.user_id where p.prop_id = $2 and upper(u.user_name) = upper($1) ) select fn_check_permission(A.user_id, $2, $3)from A ), false) ; end