Skip to content

Roles and Policies #27

Description

@sreenik250

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions