github.com/Redstoneguy129/cli@v0.0.0-20230211220159-15dca4e91917/internal/utils/templates/globals.sql (about)

     1  --
     2  -- PostgreSQL database cluster dump
     3  --
     4  
     5  SET default_transaction_read_only = off;
     6  
     7  SET client_encoding = 'UTF8';
     8  SET standard_conforming_strings = on;
     9  
    10  --
    11  -- Roles
    12  --
    13  
    14  CREATE ROLE anon;
    15  ALTER ROLE anon WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;
    16  CREATE ROLE authenticated;
    17  ALTER ROLE authenticated WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;
    18  CREATE ROLE authenticator;
    19  ALTER ROLE authenticator WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'postgres';
    20  CREATE ROLE dashboard_user;
    21  ALTER ROLE dashboard_user WITH NOSUPERUSER INHERIT CREATEROLE CREATEDB NOLOGIN REPLICATION NOBYPASSRLS;
    22  -- CREATE ROLE pgbouncer;
    23  -- ALTER ROLE pgbouncer WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;
    24  -- CREATE ROLE pgsodium_keyholder;
    25  -- ALTER ROLE pgsodium_keyholder WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;
    26  -- CREATE ROLE pgsodium_keyiduser;
    27  -- ALTER ROLE pgsodium_keyiduser WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;
    28  -- CREATE ROLE pgsodium_keymaker;
    29  -- ALTER ROLE pgsodium_keymaker WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION NOBYPASSRLS;
    30  -- CREATE ROLE postgres;
    31  -- ALTER ROLE postgres WITH NOSUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS;
    32  CREATE ROLE service_role;
    33  ALTER ROLE service_role WITH NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB NOLOGIN NOREPLICATION BYPASSRLS;
    34  CREATE ROLE supabase_admin;
    35  ALTER ROLE supabase_admin WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS PASSWORD 'postgres';
    36  CREATE ROLE supabase_auth_admin;
    37  ALTER ROLE supabase_auth_admin WITH NOSUPERUSER NOINHERIT CREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'postgres';
    38  CREATE ROLE supabase_storage_admin;
    39  ALTER ROLE supabase_storage_admin WITH NOSUPERUSER NOINHERIT CREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'postgres';
    40  CREATE ROLE supabase_functions_admin;
    41  ALTER ROLE supabase_functions_admin WITH NOSUPERUSER NOINHERIT CREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS PASSWORD 'postgres';
    42  
    43  --
    44  -- User Configurations
    45  --
    46  
    47  --
    48  -- User Config "anon"
    49  --
    50  
    51  ALTER ROLE anon SET statement_timeout TO '3s';
    52  
    53  --
    54  -- User Config "authenticated"
    55  --
    56  
    57  ALTER ROLE authenticated SET statement_timeout TO '8s';
    58  
    59  --
    60  -- User Config "authenticator"
    61  --
    62  
    63  ALTER ROLE authenticator SET session_preload_libraries TO 'safeupdate';
    64  ALTER ROLE authenticator SET statement_timeout TO '8s';
    65  
    66  --
    67  -- User Config "postgres"
    68  --
    69  
    70  ALTER ROLE postgres SET search_path TO E'\\$user', 'public', 'extensions';
    71  
    72  --
    73  -- User Config "supabase_admin"
    74  --
    75  
    76  ALTER ROLE supabase_admin SET search_path TO E'\\$user', 'public', 'auth', 'extensions';
    77  
    78  --
    79  -- User Config "supabase_auth_admin"
    80  --
    81  
    82  ALTER ROLE supabase_auth_admin SET search_path TO 'auth';
    83  ALTER ROLE supabase_auth_admin SET idle_in_transaction_session_timeout TO '60000';
    84  
    85  --
    86  -- User Config "supabase_storage_admin"
    87  --
    88  
    89  ALTER ROLE supabase_storage_admin SET search_path TO 'storage';
    90  
    91  
    92  --
    93  -- Role memberships
    94  --
    95  
    96  GRANT anon TO authenticator GRANTED BY postgres;
    97  GRANT authenticated TO authenticator GRANTED BY postgres;
    98  -- GRANT pgsodium_keyholder TO pgsodium_keymaker GRANTED BY postgres;
    99  -- GRANT pgsodium_keyholder TO postgres WITH ADMIN OPTION GRANTED BY postgres;
   100  -- GRANT pgsodium_keyiduser TO pgsodium_keyholder GRANTED BY postgres;
   101  -- GRANT pgsodium_keyiduser TO pgsodium_keymaker GRANTED BY postgres;
   102  -- GRANT pgsodium_keyiduser TO postgres WITH ADMIN OPTION GRANTED BY postgres;
   103  -- GRANT pgsodium_keymaker TO postgres WITH ADMIN OPTION GRANTED BY postgres;
   104  GRANT service_role TO authenticator GRANTED BY postgres;
   105  GRANT supabase_auth_admin TO postgres GRANTED BY supabase_admin;
   106  GRANT supabase_storage_admin TO postgres GRANTED BY supabase_admin;
   107  
   108  
   109  
   110  
   111  --
   112  -- PostgreSQL database cluster dump complete
   113  --
   114  
   115  RESET ALL;