Spaces:

GaryLeckey
/

aureon-os

Running

aureon-os / deploy /selfhost /postgres /01_roles.sql

Deploy Aureon OS (deploy/selfhost stack: nginx edge + fusion API x2 + console + HNC organ + redis + postgres; paper mode) (part 7)

c626614 verified 2 days ago

Raw History Blame Contribute Delete

521 Bytes

-- Local self-host roles. These are database roles, not provider credentials.
DO $$
BEGIN
  IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'anon') THEN
    CREATE ROLE anon NOLOGIN;
  END IF;
  IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'authenticated') THEN
    CREATE ROLE authenticated NOLOGIN;
  END IF;
  IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'service_role') THEN
    CREATE ROLE service_role NOLOGIN BYPASSRLS;
  END IF;
END
$$;

ALTER ROLE service_role BYPASSRLS;

	-- Local self-host roles. These are database roles, not provider credentials.
	DO $$
	BEGIN
	IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'anon') THEN
	CREATE ROLE anon NOLOGIN;
	END IF;
	IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'authenticated') THEN
	CREATE ROLE authenticated NOLOGIN;
	END IF;
	IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'service_role') THEN
	CREATE ROLE service_role NOLOGIN BYPASSRLS;
	END IF;
	END
	$$;

	ALTER ROLE service_role BYPASSRLS;