UseCase17 - Billing Admin Login / Authentication

Initiating Actor - Billing Admin

Description

A billing administrator logs into the Medora system using their credentials. The admin gains access to billing administrative functions.

Scenario

1. Administrator navigates to the Medora login page.

2. Administrator enters their username and password and submits the login form.

SELECT
  u.user_id,
  u.username,
  u.password,
  u.role,
  u.first_name,
  u.last_name,
  u.is_active
FROM users u
WHERE u.username = 'admin_ilija'
  AND u.role = 'BILLING_ADMIN';

3. System verifies the account is active and the password matches.

SELECT u.user_id
FROM users u
WHERE u.username = 'admin_ilija'
  AND u.is_active = TRUE
  AND u.role = 'BILLING_ADMIN';

4. System retrieves the linked admin profile.

SELECT
  a.admin_id,
  a.username,
  a.name,
  a.lastname,
  a.email
FROM admin a
JOIN users u ON u.user_id = a.user_id
WHERE u.username = 'admin_ilija';

5. Administrator is authenticated and redirected to the admin dashboard.