Changes between Initial Version and Version 1 of UseCase17

Timestamp:

06/14/26 21:04:33 (6 days ago)

Author:

236021

Comment:

--

UseCase17

@@ +1 @@
+= 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.