RSEM – Remote Desktop Environment Manager

A role-based web app for keeping a support team's project resources in one place. Each project holds its own links (portals, consoles, tools) and SOPs (written steps or uploaded PDF documents). Admins manage projects and users and decide who can see which project. Regular users see only the projects they're assigned to.

Built with Java 21, Spring Boot 4, Spring Security, Spring Data JPA, Thymeleaf and MySQL.

• Login and roles: form login with Spring Security, BCrypt password hashing, and ADMIN / USER roles
• Project access control: admins see every project; users see only the projects assigned to them
• Project management (admin): create, edit, delete and search projects
• Items per project: add, edit, delete and search items inside a project
  • LINK: a named URL
  • SOP: text content, with an optional uploaded file (PDF etc., up to 10 MB)
• User management (admin): create, edit, enable/disable and delete users, and assign them to projects
• Method-level security: @PreAuthorize on admin-only actions, plus URL rules for /admin/**

envmanager/
└── src/main/java/com/remotemanager/envmanager/
    ├── config/        SecurityConfig, WebConfig (serves /uploads), DataInitializer (seed users)
    ├── controller/    ProjectController, ItemController, AdminUserController
    ├── model/         User, Project, Item, ItemType
    ├── repository/    Spring Data JPA repositories
    └── service/       Business logic + CustomUserDetailsService
└── src/main/resources/
    ├── templates/     Thymeleaf pages (login, projects, items, users)
    └── static/        CSS and images

• User ↔ Project: many-to-many (user_projects join table)
• Project → Item: one-to-many (items are deleted with their project)

Prerequisites: JDK 21, Maven, MySQL 8

1. Create the database:

   CREATE DATABASE rsem_db;

2. Set your MySQL username and password in envmanager/src/main/resources/application.properties:

   spring.datasource.url=jdbc:mysql://localhost:3306/rsem_db
   spring.datasource.username=<your-username>
   spring.datasource.password=<your-password>

   Tables are created automatically on first run (ddl-auto=update).
3. Start the app:

   cd envmanager
   mvn spring-boot:run

4. Open http://localhost:8080 and log in.

On startup the app creates two users if they don't already exist:

Change these before using the app anywhere other than your own machine.

• Move database credentials to environment variables
• Store uploaded SOP files in cloud storage instead of the local uploads/ folder
• Switch delete actions from GET links to POST requests
• Unit and integration tests

Seetharaman Kumar Iyer, GitHub @Benex1114