crates/secd/store/pg/sql/read_session.sql


1
2
3
4
5
6
7
8

select
        i.identity_public_id
        , s.created_at
        , s.expires_at
        , s.revoked_at
from auth.session  s
join auth.identity i using (identity_id)
where secret_hash = $1;