src/include/catalog/pg_authid.dat

   1 #----------------------------------------------------------------------
   2 #
   3 # pg_authid.dat
   4 #    Initial contents of the pg_authid system catalog.
   5 #
   6 # Portions Copyright (c) 1996-2025, PostgreSQL Global Development Group
   7 # Portions Copyright (c) 1994, Regents of the University of California
   8 #
   9 # src/include/catalog/pg_authid.dat
  10 #
  11 #----------------------------------------------------------------------
  12
  13 [
  14
  15 # The C code typically refers to these roles using the #define symbols,
  16 # so make sure every entry has an oid_symbol value.
  17
  18 # The bootstrap superuser is named POSTGRES according to this data and
  19 # according to BKI_DEFAULT entries in other catalogs.  However, initdb
  20 # will replace that at database initialization time.
  21
  22 { oid => '10', oid_symbol => 'BOOTSTRAP_SUPERUSERID',
  23   rolname => 'POSTGRES', rolsuper => 't', rolinherit => 't',
  24   rolcreaterole => 't', rolcreatedb => 't', rolcanlogin => 't',
  25   rolreplication => 't', rolbypassrls => 't', rolconnlimit => '-1',
  26   rolpassword => '_null_', rolvaliduntil => '_null_' },
  27 { oid => '6171', oid_symbol => 'ROLE_PG_DATABASE_OWNER',
  28   rolname => 'pg_database_owner', rolsuper => 'f', rolinherit => 't',
  29   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  30   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  31   rolpassword => '_null_', rolvaliduntil => '_null_' },
  32 { oid => '6181', oid_symbol => 'ROLE_PG_READ_ALL_DATA',
  33   rolname => 'pg_read_all_data', rolsuper => 'f', rolinherit => 't',
  34   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  35   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  36   rolpassword => '_null_', rolvaliduntil => '_null_' },
  37 { oid => '6182', oid_symbol => 'ROLE_PG_WRITE_ALL_DATA',
  38   rolname => 'pg_write_all_data', rolsuper => 'f', rolinherit => 't',
  39   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  40   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  41   rolpassword => '_null_', rolvaliduntil => '_null_' },
  42 { oid => '3373', oid_symbol => 'ROLE_PG_MONITOR',
  43   rolname => 'pg_monitor', rolsuper => 'f', rolinherit => 't',
  44   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  45   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  46   rolpassword => '_null_', rolvaliduntil => '_null_' },
  47 { oid => '3374', oid_symbol => 'ROLE_PG_READ_ALL_SETTINGS',
  48   rolname => 'pg_read_all_settings', rolsuper => 'f', rolinherit => 't',
  49   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  50   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  51   rolpassword => '_null_', rolvaliduntil => '_null_' },
  52 { oid => '3375', oid_symbol => 'ROLE_PG_READ_ALL_STATS',
  53   rolname => 'pg_read_all_stats', rolsuper => 'f', rolinherit => 't',
  54   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  55   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  56   rolpassword => '_null_', rolvaliduntil => '_null_' },
  57 { oid => '3377', oid_symbol => 'ROLE_PG_STAT_SCAN_TABLES',
  58   rolname => 'pg_stat_scan_tables', rolsuper => 'f', rolinherit => 't',
  59   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  60   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  61   rolpassword => '_null_', rolvaliduntil => '_null_' },
  62 { oid => '4569', oid_symbol => 'ROLE_PG_READ_SERVER_FILES',
  63   rolname => 'pg_read_server_files', rolsuper => 'f', rolinherit => 't',
  64   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  65   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  66   rolpassword => '_null_', rolvaliduntil => '_null_' },
  67 { oid => '4570', oid_symbol => 'ROLE_PG_WRITE_SERVER_FILES',
  68   rolname => 'pg_write_server_files', rolsuper => 'f', rolinherit => 't',
  69   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  70   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  71   rolpassword => '_null_', rolvaliduntil => '_null_' },
  72 { oid => '4571', oid_symbol => 'ROLE_PG_EXECUTE_SERVER_PROGRAM',
  73   rolname => 'pg_execute_server_program', rolsuper => 'f', rolinherit => 't',
  74   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  75   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  76   rolpassword => '_null_', rolvaliduntil => '_null_' },
  77 { oid => '4200', oid_symbol => 'ROLE_PG_SIGNAL_BACKEND',
  78   rolname => 'pg_signal_backend', rolsuper => 'f', rolinherit => 't',
  79   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  80   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  81   rolpassword => '_null_', rolvaliduntil => '_null_' },
  82 { oid => '4544', oid_symbol => 'ROLE_PG_CHECKPOINT',
  83   rolname => 'pg_checkpoint', rolsuper => 'f', rolinherit => 't',
  84   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  85   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  86   rolpassword => '_null_', rolvaliduntil => '_null_' },
  87 { oid => '6337', oid_symbol => 'ROLE_PG_MAINTAIN',
  88   rolname => 'pg_maintain', rolsuper => 'f', rolinherit => 't',
  89   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  90   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  91   rolpassword => '_null_', rolvaliduntil => '_null_' },
  92 { oid => '4550', oid_symbol => 'ROLE_PG_USE_RESERVED_CONNECTIONS',
  93   rolname => 'pg_use_reserved_connections', rolsuper => 'f', rolinherit => 't',
  94   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  95   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  96   rolpassword => '_null_', rolvaliduntil => '_null_' },
  97 { oid => '6304', oid_symbol => 'ROLE_PG_CREATE_SUBSCRIPTION',
  98   rolname => 'pg_create_subscription', rolsuper => 'f', rolinherit => 't',
  99   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
 100   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
 101   rolpassword => '_null_', rolvaliduntil => '_null_' },
 102 { oid => '8916', oid_symbol => 'ROLE_PG_SIGNAL_AUTOVACUUM_WORKER',
 103   rolname => 'pg_signal_autovacuum_worker', rolsuper => 'f', rolinherit => 't',
 104   rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
 105   rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
 106   rolpassword => '_null_', rolvaliduntil => '_null_' },
 107
 108 ]