Copyright © 2026 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

@article{196306,
        author = {Megha Sangle and Shreya Gawai and Rasika Gondchar and Prasad Chopade and Pravin Thakare},
        title = {Secure and Idempotent Batch Provisioning of Student Accounts for Hostel Mess Management Systems Using Supabase Auth and Streamlit},
        journal = {International Journal of Innovative Research in Technology},
        year = {2026},
        volume = {12},
        number = {11},
        pages = {2567-2576},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=196306},
        abstract = {Hostel mess management systems are increasingly being adopted to digitize student registration, meal attendance, billing, menu selection, and administrative reporting. Although many existing systems focus on operational modules such as attendance tracking and feedback collection, limited attention has been given to the secure provisioning of student accounts and the integrity of identity-linked records. In real-world deployments, weak onboarding practices such as duplicate account creation, inconsistent database mappings, insecure default passwords, and improper handling of elevated credentials can lead to operational failures and security vulnerabilities.This paper proposes a secure and idempotent batch provisioning framework for student accounts in hostel mess management systems using Supabase Auth Admin APIs and Streamlit. The proposed framework creates student identities through a three-stage pipeline involving authentication account creation, profile insertion, and hostel-specific student record generation. To ensure safe re-execution of the provisioning process, the framework incorporates idempotent operations using unique constraints, primary keys, and upsert mechanisms. The architecture also integrates role-based access control, Row Level Security, and secure handling of service-role credentials to prevent unauthorized access and maintain database integrity. The study further examines password lifecycle management, temporary credential strategies, recovery from partial failures, and scalability considerations for large student cohorts. Experimental analysis demonstrates that the proposed approach minimizes duplicate records, preserves referential consistency across authentication and application tables, and supports reliable onboarding even when the provisioning script is re-run multiple times. The framework provides a production-oriented foundation for secure student onboarding and can be extended to support additional hostel mess management functionalities such as attendance monitoring, QR-based meal authentication, billing, and feedback systems.},
        keywords = {Hostel Mess Management System, Student Account Provisioning, Batch User Creation, Idempotency, Supabase Auth, Streamlit, Row Level Security, RBAC, Student Onboarding, Database Integrity, Authentication, Access Control, Secure Provisioning},
        month = {April},
        }