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 本製品 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 本製品.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The scope consent identifier (UUID). | |
| UserId | String | Users.Id | The identifier (UUID) of the user associated with the scope consent. |
| OIDCApplicationId | String | OIDCApplications.Id | The identifier (UUID) of the application associated with the scope consent. |
| ApplicationName | String | The name of the application associated with the scope consent. | |
| ApplicationType | String | The type of the application associated with the scope consent. Possible values are: 'PINGONE' and 'EXTERNAL'. | |
| Scope | String | A set of strings that specifies the scopes associated with this OAuth scope consent. | |
| Status | String | A string that specifies whether the consent is valid or not. Possible values are: 'ACCEPTED', 'REVOKED', and 'DECLINED'. | |
| ConsentedAt | Datetime | The time when the user consented to the scopes. | |
| DeviceType | String | The type of the remote device used to make the consent. | |
| Browser | String | The name of the browser used in the device where the consent was made. | |
| BrowserVersion | String | The version of the browser used in the device where the consent was made. | |
| OperatingSystem | String | The name of the operating system used in the device where the consent was made. | |
| OperatingSystemVersion | String | The version of the operating system used in the device where the consent was made. | |
| IPAddress | String | The IP address of the device used to make the consent. | |
| City | String | The city resolved from the IP address. | |
| Region | String | The region resolved from the IP address. | |
| State | String | The state resolved from the IP address. | |
| Country | String | The country resolved from the IP address. | |
| UpdatedAt | Datetime | The time at which the scope consent was last updated. |