[ehb54/us3_sql] f599cf: Permission checks: take the caller from p_personGUID
Branch: refs/heads/ehb54-issue-1144 Home: https://github.com/ehb54/us3_sql Commit: f599cff1ca12470329859623e5b9199a63265889 https://github.com/ehb54/us3_sql/commit/f599cff1ca12470329859623e5b9199a6326... Author: ehb54 <brookes@uthscsa.edu> Date: 2026-10-13 (Tue, 13 Oct 2026) Changed paths: M us3_analyte_procs.sql M us3_buffer_procs.sql M us3_exp_procs.sql M us3_model_procs.sql M us3_mrecs_procs.sql M us3_noise_procs.sql M us3_people_procs.sql M us3_proj_procs.sql M us3_protocol_procs.sql M us3_report_procs.sql M us3_solution_procs.sql Log Message: ----------- Permission checks: take the caller from p_personGUID The verify_*_permission functions counted the caller's ownership rows with @US3_ID before calling verify_user, which is what sets @US3_ID for the call. So the count was for whoever @US3_ID named at that moment, not necessarily the caller. The functions now look up the caller from p_personGUID, the GUID that verify_user checks in the same call. delete_person now calls config() before using @OK and @US3_ADMIN. Part of ehb54/ultrascan-tickets#1144 Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> Commit: ab90d5ff1eb487aeebc1a5443d33355beb249c96 https://github.com/ehb54/us3_sql/commit/ab90d5ff1eb487aeebc1a5443d33355beb24... Author: ehb54 <brookes@uthscsa.edu> Date: 2026-10-13 (Tue, 13 Oct 2026) Changed paths: M us3_mrecs_procs.sql Log Message: ----------- verify_mrecs_permission: check the requested mrecsID The ownership count joined the caller's experiments to every model record, so owning any model record passed the check for all of them. The count is now limited to p_mrecsID, as in the other permission functions. Part of ehb54/ultrascan-tickets#1144 Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> Compare: https://github.com/ehb54/us3_sql/compare/f599cff1ca12%5E...ab90d5ff1eb4 To unsubscribe from these emails, change your notification settings at https://github.com/ehb54/us3_sql/settings/notifications
participants (1)
-
emre brookes