Discord-like role authorization
I'm interested in adding authorization similar to Discord's roles where each group can define their own custom roles and permissions. The more investigate Postgres's roles, they seem to be for statically defined positions.
Would this be an appropriate use case to have each group's roles be a separate Postgres role under the hood? Or would I be better off creating my own "roles" table with permissions and RLS policies that read the permissions for the user's given role?
Any help is appreciated, thanks!
Would this be an appropriate use case to have each group's roles be a separate Postgres role under the hood? Or would I be better off creating my own "roles" table with permissions and RLS policies that read the permissions for the user's given role?
Any help is appreciated, thanks!
