I am student studying in Database Administration (first year), one of our task requires a to design a login form for corporate and regular users. Below are the requirements for the username and password fields:
User name should be any combination of letters and numbers at least five characters in length and no more than 20. (Same requirements as user login ID for corporate account ID).
The corporate password is a 64-digit key of alpha numerical values that all employees in the corporation has access to.
The regular password for both corporate client employees/users and regular users should contain these types of characters: one alphanumeric, one number, one uppercase english letter, one lowercase english letters and one special character and should be at least 8 characters in length and no more than 20.
I do not have any problem in designing the regular expression for regular username and password.
The following is the regular expression for the regular user's password field (meets above requirements):
^(?=.*?[A-Z])(?=.*?[a-z])(?=.*?[0-9])(?=.*?[#?!@$%^&*-]).{8,20}$
The problem now is that I have no clues on how to create a 64-digit key of alpha numerical values nor to store in Database for the corporate id and password