Today, role management is used. I checked the ASPNET built-in management table and recorded it.
1. aspnet_membership table structure and example
------------------------------------------
Applicationid uniqueidentifier Application No.
-----------------------------------------------
Userid uniqueidentifier user ID
----------------------------------------------
Password nvarchar (128) password (plaintext, hash, encrypted, if the base-64-encoded)
--------------------------------
Passwordformat int password format (0 plaintext, 1 Haha, 2 encrypted)
---------------------------------------------
The Random Number of passwordsalt nvarchar (128) 128-bit is used to generate the number of passwords, which is stored in the base-64-encoded format.
-----------------------------------------------
Mobilepin nvarchar (16) User's mobile password pin
--------------------------------------------------
Email nvarchar (256) User e-Mai
-----------------------------------------------
Loweredemail nvarchar (256) User email in lower case
-----------------------------------------------
Passwordquestion nvarchar (256) password Problem
-------------------------------------------
Passwordanswer nvarchar (128) password answer
-------------------------------------
Isapproved bit audit 1 audit, 0 not reviewed
------------------------------------------------
Whether islockedout bit is locked; 1: locked; 0: unlocked
------------------------------------------------
Date and time when the createdate datetime account was created
-----------------------------------------------
Lastlogindate the date and time when the datetime user last logged in
----------------------------------------------
Lastpasswordchangeddate the last modification date and time of the User Password
----------------------------------------
Lastlockoutdate the date and time when the user is last locked by datetime
------------------------------------
Failedpasswordattemptcount number of times the int password attempt failed
-------------------------------------------
Failedpasswordattempt-windowstart datetime
If failedpasswordattemptcount is not 0, record the date and time of the first logon failure.
----------------------
Failedpasswordanswer-attemptcount number of failed attempts to access the int Password
----------------------------------
Failedpasswordanswer-attemptwindowstart datetime
If failedpasswordanswerattemptcount is not 0, record the date and time when the first Password failed.
----------------------------------
Comment ntext remarks
---
2. sqlmembershipprovider-related stored procedures
1) aspnet_Membership_ChangePassword-QuestionAndAnswer
Change the password of a specified user
----------------------------------------------------------
2) aspnet_membership_createuser
Add a new member user to the membership database.
Records user information to the aspnet_users and aspnet_membership tables,
If necessary, add a new application site to the aspnet_applications table.
---------------------------------------------------------------------------
3) aspnet_membership_findusersbyemail
Retrieve records matching the specified email address and applicationid from the aspnet_membership table
------------------------------------------------------------------------
4) aspnet_membership_findusersbyname
Retrieve records matching the specified user name and applicationid site number from the aspnet_membership table
------------------------------------------
5) aspnet_membership_getallusers
Retrieve records of all users matching the applicationid site number from the aspnet_membership table
------------------------------
6) aspnet_membership_getnumberofusersonline
Obtain the number of online members based on the last activity date.
-----------------------------
7) aspnet_membership_getpassword
Obtain the password of the specified user from the database. Retrieve the password Based on the password answer provided by the user.
-----------------------------------
8) aspnet_membership_getpasswordwithformat
Obtain the password of the specified user from the database.
When comparing passwords, it is used to retrieve passwords.
(For example, when a valid user needs to verify the password ).
----------------------------------------
9) aspnet_membership_getuserbyemail
By using the given email and applicationid
Retrieve records from the aspnet_membership table
----------------------------------------
10) aspnet_membership_getuserbyname
Given the user name and applicationid, from
Retrieve records from the aspnet_membership table
----------------------------------------------
11) aspnet_membership_getuserbyuserid
Given the user and application ID, from
Retrieve records from the aspnet_membership table
-------------------------------------------
12) aspnet_membership_resetpassword
Restores the password of a specified user based on the password answer.
----------------------------------------------
13) aspnet_membership_setpassword
Set the password of the specified user:
Enter the password in the Stored Procedure
---------------------------------
14) aspnet_membership_unlockuser
Set the islockedout bit to 0,
Restore login permissions of a specified user
-----------------------------------
15) aspnet_membership_updateuser
Update the last activity date of the user in the aspnet_users table
And the e-mail, comment, review status, and last login date in aspnet_membership
--------------------------------------
16) aspnet_membership_updateuserinfo
Lock the data update account for the user specified in the aspnet_users and aspnet_membership tables.
Used to join the provider method to track failed password attempts and failed password answer attempts.
----------------------------------------
17) aspnet_users_createuser
Add a user to the aspnet_users table
Called through aspnet_membership_createuser.
-----------------------------------------------
18) aspnet_users_deleteuser
Delete a user from the aspnet_membership table and other SQL providers.
Table, including aspnet_users.
-----------------------------------------------