I think this module suits to my requirement.: Protected Pages
Hope this helps for someone. Some details about it (from its project page):
... allows the administrator to secure any page in your website by password. You just need to go to configuration page of this module and add path, password. After that the added path will be password protected. This module also allows you to send the details of this protected page to multiple users by email.
