UserOAuthScopeConsents
The OAuth scope consents of the user.
View-Specific Information
SELECT
Reading data from this entity requires Read OAuth Consent/agreements:read:oauthConsent permission.We recommend using the built-in Identity Data Admin role.
To execute SELECT statements on this entity, the UserId column must be specified in the criteria as shown in the examples below:
SELECT * FROM Administrators.UserOAuthScopeConsents WHERE UserId = 'f45bb04b-d7ee-4f84-ab83-7fe3919405ae';
SELECT * FROM Administrators.UserOAuthScopeConsents WHERE UserId IN ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '4cbf5435-6c39-49f9-8c8f-cee7c1cd8a6b');
The connector uses the PingOne Platform API to process WHERE clause conditions built with the following columns and operators.
- UserId supports the following operators: =, IN.
All other filters are processed client-side within the connector.
INSERT
Creating data in this table requires Create OAuth Consent/agreements:create:oauthConsent permission.Refer to the query example below:
INSERT INTO Administrators.UserOAuthScopeConsents (UserId, OIDCApplicationId, ApplicationName, ApplicationType, Scope, Status, DeviceType, Browser, BrowserVersion, OperatingSystem, OperatingSystemVersion) VALUES ('f45bb04b-d7ee-4f84-ab83-7fe3919405ae', '8f2c6a33-1f7f-458e-8b58-f92507742293', 'My OIDC App', 'EXTERNAL', 'openid', 'ACCEPTED', 'Laptop', 'Safari', '100.1', 'Mac OS', '1.2')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The scope consent identifier (UUID). | |
| UserId | String | False | Users.Id |
The identifier (UUID) of the user associated with the scope consent. |
| OIDCApplicationId | String | False | OIDCApplications.Id |
The identifier (UUID) of the application associated with the scope consent. |
| ApplicationName | String | False |
The name of the application associated with the scope consent. | |
| ApplicationType | String | False |
The type of the application associated with the scope consent. Possible values are: 'PINGONE' and 'EXTERNAL'. | |
| Scope | String | False |
A set of strings that specifies the scopes associated with this OAuth scope consent. | |
| Status | String | False |
A string that specifies whether the consent is valid or not. Possible values are: 'ACCEPTED', 'REVOKED', and 'DECLINED'. | |
| ConsentedAt | Datetime | True |
The time when the user consented to the scopes. | |
| DeviceType | String | False |
The type of the remote device used to make the consent. | |
| Browser | String | False |
The name of the browser used in the device where the consent was made. | |
| BrowserVersion | String | False |
The version of the browser used in the device where the consent was made. | |
| OperatingSystem | String | False |
The name of the operating system used in the device where the consent was made. | |
| OperatingSystemVersion | String | False |
The version of the operating system used in the device where the consent was made. | |
| IPAddress | String | False |
The IP address of the device used to make the consent. | |
| City | String | False |
The city resolved from the IP address. | |
| Region | String | False |
The region resolved from the IP address. | |
| State | String | False |
The state resolved from the IP address. | |
| Country | String | False |
The country resolved from the IP address. | |
| UpdatedAt | Datetime | True |
The time at which the scope consent was last updated. |