Anyone know how I can manually set a jwt for auth ...
# sqlk
kennethcassel
10/20/2021, 5:26 PMAnyone know how I can manually set a jwt for auth in sql?
I want to run an explain command against a query but as an auth’d user so I can test RLS performance
e
easystreet
10/21/2021, 8:32 PMthis works for me from pgadmin connected as a login with `SUPERUSER`:
easystreet
10/21/2021, 8:33 PM Copy code
set local role authenticated;
set local request.jwt.claim.sub = '<uid>';
SELECT * FROM foos;k
kennethcassel
10/21/2021, 8:33 PMohh seems so straightforward now lol!
e
easystreet
10/21/2021, 8:33 PMdoes not work from the supabase dashboard sql editor
k
kennethcassel
10/21/2021, 8:34 PMyeah makes sense!
kennethcassel
10/21/2021, 8:34 PMthanks for the help!
kennethcassel
10/21/2021, 9:57 PMdoesn't seem like any of the logins are default
SUPERUSERkennethcassel
10/21/2021, 10:27 PMah fixed it by setting my postgres user to superuser via the sql editor in browser
e
easystreet
10/23/2021, 1:44 PMhuh, i haven't used discord threads. strange that i didn't get notified on posts ITT
easystreet
10/23/2021, 1:45 PMi created a new login with
SUPERUSEReasystreet
10/23/2021, 1:47 PMgenerally i try not to change anything originally created/managed by supabase. at one point
postgresSUPERUSERSUPERUSERpostgres