Admin Registration(Existing Admin)

Actor: Admin

An existing admin promotes an already registered user to admin role, granting them full read-write access to the entire system.

1. The admin navigates to the user management section of the platform.

2. The system displays a list of all registered users.

SELECT user_id, username, email, name, surname
FROM USERS
ORDER BY created_at DESC;

3. The admin selects a user and assigns them the admin role.

4. The system inserts a new record into the ADMINS table using the selected user's user_id.

INSERT INTO ADMINS (user_id)
VALUES (1);

5. The system confirms the user has been successfully promoted to admin and sends them a notification.

INSERT INTO NOTIFICATION (content, is_read, created_at)
VALUES ('You have been granted admin privileges on the platform.', FALSE, CURRENT_TIMESTAMP);