This page provides an example of what is possible for password protecting pages on Squarespace.
Secure Page 1 - PW = kohler1
Secure Page 2 - PW = kohler2
Comments on Limitations:
Once signed in to a page, you remain so until re-opening your browser
Each page can have only one password.
We can get creative and get around this by having duplicates of a secured page, defining a new password for each duplicate. The down side is when an update to the page is needed, we can update the original page, but will need to scrap all copies of the page and re-copy the page. This will become more tedious with each additional login needed, but should not be much of a problem with just a handful of pages.