RBAC Dashboard

[jdgamble555]

It would be cool to have a dashboard for Role Based Authentication Control, but for regular users, not "managed by supabase."

Imagine a dashboard with 3 tabs:

• Roles
• Users
• Permission

Roles

Roles allow you to add possible roles, ie:

• Sudo
• Admin
• Editor
• Subscriber
• User

etc...

Users

Users would list the users and allow you to edit their role.

• ID
• Email
• User Role

Permissions

Permission

• Role
• Table
• Select
• Create
• Update Before
• Update After
• Delete

There would be a supabase function called isAuthorized() similar to authorize() that could run on any RBAC table.

There would be a trigger function to automatically create the possible Tables in the permissions table every time a new table is created. That way the developer never has to think about it.

This could get more complex later to add isOwner() and maybe automatic created_by to each table. The possibilities are limitless, but this could streamline development for a lot of projects re-writing the same concepts.

Of course, this would be built into Supabase.

J