mirror of https://github.com/artifacthub/hub.git
12 lines
392 B
SQL
12 lines
392 B
SQL
-- get_user_tfa_config returns the 2fa configuration of the provided user.
|
|
create or replace function get_user_tfa_config(p_user_id uuid)
|
|
returns setof json as $$
|
|
select json_strip_nulls(json_build_object(
|
|
'enabled', u.tfa_enabled,
|
|
'recovery_codes', u.tfa_recovery_codes,
|
|
'url', u.tfa_url
|
|
))
|
|
from "user" u
|
|
where u.user_id = p_user_id;
|
|
$$ language sql;
|