martindonadieu@supabase_auth_admin

v0.0.1•Created a year ago•By martindonadieu

supabase_auth_admin

Useful extensions for Supabase Auth, allow users to be admin, this is useful to allow exceptions in RLS, for impersonation, or other use cases.

Usage

Functions

  • is_admin() - check if the current user is admin. This is made to use in RLS, This is safe to use in Frontend
  • is_admin(user_id) - check if the user is admin. This is made to use in your backend
  • set_admin(user_id) - set the user as admin, only admin can do this or the first user

Installation

dbdev install riderx-supabase_auth_admin --connection <CONNECTION_STRING>

or

select * from dbdev('riderx-supabase_auth_admin')

then:

create extension supabase_auth_admin;

or to install in a separate schema (recommended):

create extension supabase_auth_admin with schema extensions;

Install

  1. Install the dbdev package manager
  2. Install the package:
select dbdev.install('martindonadieu@supabase_auth_admin');
create extension "martindonadieu@supabase_auth_admin"
    version '0.0.1';

Downloads

  • 5 all time downloads
  • 0 downloads in the last 30 days
  • 0 downloads in the last 90 days
  • 0 downloads in the last 180 days