UseCase17 - Billing Admin Login / Authentication

Initiating Actor - Billing Admin

Description

A system 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 = '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 = 'ADMIN';

4. System retrieves the linked admin profile.

SELECT
  a.admin_id,
  a.user_id,
  a.permissions
FROM admin a
WHERE a.user_id = (SELECT user_id FROM users WHERE username = 'admin_ilija');

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