Details of table(s) used to store AAD authentication tokens

• tristan.slaughter

  SSC Veteran

  Points: 207

  More actions

  February 2, 2015 at 7:04 am

  #303018

  Hi

  Does anyone know the names of the SQL Server tables and their field definitions that are used to store Azure Active Directory authentication tokens?

  Are these pre-defined system tables or do I need to set these up myself?

  The article at the link below contains the following:

  "Now add a class named EFADALContext.cs into the Utils folder. This class will derive from Entity Framework’s DbContext class and handle mapping the PerWebUserCache object to the proper table in SQL Server."

  I am trying to find out the name and field definitions of this particular table in SQL Server so that I can write a SQL script to create it.

  https://weblogs.asp.net/dwahlin/adding-azure-active-directory-and-owin-code-into-an-angularjs-asp-net-mvc-application-to-handle-user-authentication

  Thanks in advance

  Tristan

• jayendranarumugam

  SSC Veteran

  Points: 264

  More actions

  July 22, 2017 at 4:01 am

  #1952232

  The Table name will be like UserTokenCache. It will be generated by the system itself.

  The columns in the table are 

  UserTokenCacheId - int, not null
  webUserUniqueId - nvarchar(max),null
  cacheBits -varbinary(max),null)
  LastWrite- datetime,not null

  Hope this Helps,
  Jay