OAuth2 user consent grant. Stores which scopes a user has approved for a given OAuth2 client application. Table locale (per tenant).

Show:

ID_OAUTH2_GRANT

Int(11)

Unique identifier.

ID_USER

Int(11)

User identifier (FK TAB_USER.ID_USER).

OG_CLIENT_HOST

Varchar(255)

Host of the redirect URI the user consented to, for a dynamically registered MCP client, empty for the app itself.


Default: ''

OG_CLIENT_ID

Varchar(255)

OAuth2 client identifier (app code).

OG_CLIENT_KEY

Varchar(64)

Client key of a dynamically registered MCP client (derived from its signed client_id), empty for the app itself. One grant per (user, app, client key).


Default: ''

OG_CLIENT_NAME

Varchar(100)

Self-declared name of a dynamically registered MCP client (RFC 7591 client_name, signed in its client_id), empty for the app itself. Display only, never a proof of identity.


Default: ''

OG_CREATED_AT

Datetime

Grant creation date.

OG_REDIRECT_URI

Varchar(255)

Exact redirect URI the user consented to, for a dynamically registered MCP client, empty for the app itself. The grant only skips the consent screen for this URI.


Default: ''

OG_SCOPES

Varchar(1000)

Space-separated list of approved scopes.


Default: NULL

OG_UPDATED_AT

Datetime

Grant last update date.