Tables [dbo].[MssWebPersistedGrant]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created9:07:53 AM Thursday, May 23, 2024
Last Modified9:08:58 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_MssWebPersistedGrant: KeyKeynvarchar(200)400
No
Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\TypeClientIdnvarchar(200)400
No
CreationTimedatetime28
No
Datanvarchar(max)max
No
Indexes IX_MssWebPersistedGrant_Expiration: ExpirationExpirationdatetime28
Yes
Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\TypeSubjectIdnvarchar(200)400
Yes
Indexes IX_MssWebPersistedGrant_SubjectId_ClientId_Type: SubjectId\ClientId\TypeTypenvarchar(50)100
No
SessionIdnvarchar(max)max
Yes
Descriptionnvarchar(max)max
Yes
ConsumedTimenvarchar(max)max
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_MssWebPersistedGrant: KeyPK_MssWebPersistedGrantKey
Yes
IX_MssWebPersistedGrant_ExpirationExpiration
IX_MssWebPersistedGrant_SubjectId_ClientId_TypeSubjectId, ClientId, Type
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MssWebPersistedGrant]
(
[Key] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClientId] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreationTime] [datetime2] NOT NULL,
[Data] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Expiration] [datetime2] NULL,
[SubjectId] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SessionId] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConsumedTime] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebPersistedGrant] ADD CONSTRAINT [PK_MssWebPersistedGrant] PRIMARY KEY CLUSTERED  ([Key]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MssWebPersistedGrant_Expiration] ON [dbo].[MssWebPersistedGrant] ([Expiration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MssWebPersistedGrant_SubjectId_ClientId_Type] ON [dbo].[MssWebPersistedGrant] ([SubjectId], [ClientId], [Type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT INSERT ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT DELETE ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GRANT UPDATE ON  [dbo].[MssWebPersistedGrant] TO [MssExec]
GO
Uses