Introduced in SQLPage 0.7.2.

Returns the username 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;

basic_auth_password basic_auth_username cookie current_working_directory environment_variable exec fetch hash_password header link path persist_uploaded_file protocol random_string read_file_as_data_url read_file_as_text request_method run_sql uploaded_file_mime_type uploaded_file_name uploaded_file_path url_encode variables version