== Admin Registration(Existing Admin)

=== Authors: **Existing 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.
{{{#!sql
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.
{{{#!sql
INSERT INTO ADMINS (user_id)
VALUES (1);
}}}

**5.**  The system confirms the user has been successfully promoted to admin and sends them a notification.
{{{#!sql
INSERT INTO NOTIFICATION (content, is_read, created_at)
VALUES ('You have been granted admin privileges on the platform.', FALSE, CURRENT_TIMESTAMP);
}}}