What are best practices for creating users in the auth table as an admin?
Working on a rather complex LMS system with tons of different roles and permissions levels. I am often getting stuck working with the Auth system and how it is separate from the other database tables.
For example - I have issues with an admin creating a user. Seems to have trouble because it isn't the user registering the account.
I want to create a record in the auth table. Then a public.users record with more info (such as if they are an admin, which group they are in, etc). It seems the RPC function I am trying to use keeps failing for permissions related issues. I have also had it work all different types of ways.
What are some best practices to working with the user system in this manner?
For example - I have issues with an admin creating a user. Seems to have trouble because it isn't the user registering the account.
I want to create a record in the auth table. Then a public.users record with more info (such as if they are an admin, which group they are in, etc). It seems the RPC function I am trying to use keeps failing for permissions related issues. I have also had it work all different types of ways.
What are some best practices to working with the user system in this manner?
