Is it possible to alter the auth.users table to change tokens from null to ' '?
I am having a problem, i have already an auth user that was verified through email (manager) and i want them to be able to create an employee through the frontend and when they create the employee through the frontend they are inserted through to the auth.user table and employees table but the problem is they can not be verified through superbase because the detaults are null for the tokens and not ' ' which superbase uses to authenticate all users, and i am not able to change that
-- Start transaction for safety
BEGIN;
-- Change confirmation_token default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN confirmation_token SET DEFAULT ''::character varying;
-- Change recovery_token default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN recovery_token SET DEFAULT ''::character varying;
-- Change email_change_token_new default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN email_change_token_new SET DEFAULT ''::character varying;
-- Change email_change default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN email_change SET DEFAULT ''::character varying;
-- Commit transaction
COMMIT;
bellow is the error that i get when i run the full script
ERROR: 42501: must be owner of table users
Am i doing something wrong?
-- Start transaction for safety
BEGIN;
-- Change confirmation_token default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN confirmation_token SET DEFAULT ''::character varying;
-- Change recovery_token default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN recovery_token SET DEFAULT ''::character varying;
-- Change email_change_token_new default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN email_change_token_new SET DEFAULT ''::character varying;
-- Change email_change default from NULL to ''
ALTER TABLE auth.users
ALTER COLUMN email_change SET DEFAULT ''::character varying;
-- Commit transaction
COMMIT;
bellow is the error that i get when i run the full script
ERROR: 42501: must be owner of table users
Am i doing something wrong?
