I have created 2 roles and 2 policies like below
CREATE ROLE DEPT_ROLE ;
CREATE POLICY "Enable read access for all users" ON "public"."TEMPLOYEE_MAS"
AS PERMISSIVE FOR ALL
TO dept_role
CREATE ROLE dept_role_insert ;
CREATE POLICY "employee_mas insert role" ON "public"."TEMPLOYEE_MAS"
AS PERMISSIVE FOR INSERT
TO dept_role_insert
MY Question:
I have 5 users in auth.users tables
I want to give the above roles to a user available in auth.users
Can you guide me?
I have created 2 roles and 2 policies like below
CREATE ROLE DEPT_ROLE ;
CREATE POLICY "Enable read access for all users" ON "public"."TEMPLOYEE_MAS"
AS PERMISSIVE FOR ALL
TO dept_role
CREATE ROLE dept_role_insert ;
CREATE POLICY "employee_mas insert role" ON "public"."TEMPLOYEE_MAS"
AS PERMISSIVE FOR INSERT
TO dept_role_insert
MY Question:
I have 5 users in auth.users tables
I want to give the above roles to a user available in auth.users
Can you guide me?