Changes between Version 1 and Version 2 of UseCase17

Timestamp:

09/19/26 17:12:24 (4 days ago)

Author:

236021

Comment:

--

UseCase17

@@ -4 +4 @@
 
 == Description ==
-A system administrator logs into the Medora system using their credentials. The admin gains access to billing administrative functions.
+A billing administrator logs into the Medora system using their credentials. The admin gains access to billing administrative functions.
 
 == Scenario ==
@@ -24 +24 @@
 FROM users u
 WHERE u.username = 'admin_ilija'
-  AND u.role = 'ADMIN';
+  AND u.role = 'BILLING_ADMIN';
 }}}
 
@@ -35 +35 @@
 WHERE u.username = 'admin_ilija'
   AND u.is_active = TRUE
-  AND u.role = 'ADMIN';
+  AND u.role = 'BILLING_ADMIN';
 }}}
 
@@ -44 +44 @@
 SELECT
   a.admin_id,
-  a.user_id,
-  a.permissions
+  a.username,
+  a.name,
+  a.lastname,
+  a.email
 FROM admin a
-WHERE a.user_id = (SELECT user_id FROM users WHERE username = 'admin_ilija');
+JOIN users u ON u.admin_id = a.admin_id
+WHERE u.username = 'admin_ilija';
 }}}