The sqlpage.basic_auth_password function

Introduced in SQLPage 0.7.2.

Returns the password from the Basic Authentication header of the request. If the header is not present, this function raises an authorization error that will prompt the user to enter their credentials.

Example

SELECT 'authentication' AS component,
    (SELECT password_hash from users where name = sqlpage.basic_auth_username()) AS password_hash,
    sqlpage.basic_auth_password() AS password;