1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
select oauth_validation_public_id
, i.identity_public_id
, ov.access_token
, ov.raw_response
, ov.created_at
, ov.validated_at
, iov.revoked_at
, iov.deleted_at
, op.name as oauth_provider_name
, op.flow as oauth_provider_flow
, op.base_url as oauth_provider_base_url
, op.response_type as oauth_provider_response_type
, op.default_scope as oauth_provider_default_scope
, op.client_id as oauth_provider_client_id
, op.client_secret as oauth_provider_client_secret
, op.redirect_url as oauth_provider_redirect_url
, op.created_at as oauth_provider_created_at
, op.deleted_at as oauth_provider_deleted_at
from secd.oauth_validation ov
join secd.oauth_provider op using(oauth_provider_id)
left join secd.identity_oauth_validation iov using(oauth_validation_id)
left join secd.identity i using(identity_id)
where oauth_validation_public_id = $1;
|
