0

I need some information about purpose db tables.

For example, in table AspNetUsers what is the purpose of the

SecurityStamp or LockoutEndDateUtc columns ? How can I use the columns ?

There is someone that can help me please ?

Thank in advance

Alan392
  • 675
  • 2
  • 12
  • 26
  • If you want DB tables I assume you want to query it directly. Maybe you'll have access to `[DB name].INFORMATION_SCHEMA.TABLES` or `[DB name].INFORMATION_SCHEMA.COLUMNS`. Using those two tables I would be able to see table and column names even of the tables I had no SELECT permission for. (given that is MSSQL DB) – Justinas Marozas Jan 11 '18 at 12:09
  • Thank you for your answer, but i need some information about the puropose columns. – Alan392 Jan 11 '18 at 13:19
  • You'll see column value type, length in if it's nullable or not, etc. in `INFORMATION_SCHEMA.COLUMNS`. Again, if it's MSSQL. Other DBs should have ways to query schema as well though. – Justinas Marozas Jan 11 '18 at 13:22
  • I don't need this information (value type, length etc..) I need the column purpose !!!! In SecurityStamp what information i find ???? – Alan392 Jan 11 '18 at 13:26

1 Answers1

1

On SecurityStamp:

the primary purpose of the SecurityStamp is to enable sign out everywhere. The basic idea is that whenever something security related is changed on the user, like a password, it is a good idea to automatically invalidate any existing sign in cookies, so if your password/account was previously compromised, the attacker no longer has access. more details in this answer

LockoutEndDateUtc, set together with LockoutEnabled, will allow locking out the user. more details in this blog post.

Justinas Marozas
  • 2,482
  • 1
  • 17
  • 37