= 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.

{{{
#!sql
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.

{{{
#!sql
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.

{{{
#!sql
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.