[PostgreSQL] CREATE POLICY with USERs in the schema errors out with user does not exist

[priyanshi-yb]

Jira Link: DB-13444
If there are some Policies in the source schema that are associated with USERs. In that case, those will error in the import schema phase with the following error as Voyager currently does not export Users/Grants in the export schema phase.

ERROR: role "regress_rls_group" does not exist (SQLSTATE 42704)

Suggestion: Create the Users manually before import schema to get these policies created in target YugabyteDB

example -

CREATE TABLE public.z1 (
    a integer,
    b text
);
CREATE ROLE regress_rls_group;
CREATE POLICY p2 ON public.z1 TO regress_rls_group USING (((a % 2) = 1));