fn_login


Parameters

Name Type Mode
prop_code citext IN
login_name citext IN
login_password text IN
device_name text IN (DEFAULT NULL)
renew_session boolean IN (DEFAULT false)
res_code smallint OUT
res_msg text OUT
log_id bigint OUT
user_id integer OUT
user_name citext OUT
user_group_id integer OUT
user_group_name text OUT
user_group_type character OUT
full_name citext OUT
job_position text OUT
email text OUT
mobile text OUT
telephone text OUT
current_shift character OUT
logintime timestamp with time zone OUT
prop_id integer OUT
prop_name citext OUT
prop_group_id integer OUT
prop_group_name text OUT
permissions json[] OUT
image_url text OUT

Definition