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, user_name, surname
FROM USERS
ORDER BY user_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, assigned_at)
VALUES (1, CURRENT_TIMESTAMP);

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

INSERT INTO NOTIFICATION (notification_content, content_type, is_read, user_id, story_id, notification_created_at)
VALUES ('You have been granted admin privileges on the platform.', 'admin_promotion', FALSE, 1, NULL, CURRENT_TIMESTAMP);