Finalize RBAC implementation for exec, pledge, brother, guest, and director roles

[kairavipandya]

[PranayChintakunta]

Role enum and validation enforced in portal-schema.sql (admin, exec, director, brother, pledge).

Completed.