What are stored in PersistedGrant table for IdentityServer

Question

I stored IdentityServer tables in SQL database. There is a table, PersistedGrants. When the type is "AuthorizationCode", which column that stores the Authorization Code? Is it the key in the table?

Tore Nestenius · Accepted Answer · 2024-11-09 11:01:28Z

1

The table definition for that table is shown below. From that you see the primary key of the table in an integer.

CREATE TABLE "PersistedGrants" (
    "Id" INTEGER NOT NULL CONSTRAINT "PK_PersistedGrants" PRIMARY KEY AUTOINCREMENT,
    "Key" TEXT NULL,
    "Type" TEXT NOT NULL,
    "SubjectId" TEXT NULL,
    "SessionId" TEXT NULL,
    "ClientId" TEXT NOT NULL,
    "Description" TEXT NULL,
    "CreationTime" TEXT NOT NULL,
    "Expiration" TEXT NULL,
    "ConsumedTime" TEXT NULL,
    "Data" TEXT NOT NULL
);

Then there is a index on the key field

CREATE UNIQUE INDEX "IX_PersistedGrants_Key" ON "PersistedGrants" ("Key");

Here is what the table can look like with sample data:

answered Nov 9, 2024 at 11:01

Tore Nestenius

20.4k5 gold badges36 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What are stored in PersistedGrant table for IdentityServer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related