pg_authid.dat 4.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  1. #----------------------------------------------------------------------
  2. #
  3. # pg_authid.dat
  4. # Initial contents of the pg_authid system catalog.
  5. #
  6. # Portions Copyright (c) 1996-2022, 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. # The C code typically refers to these roles using the #define symbols,
  14. # so make sure every entry has an oid_symbol value.
  15. # The bootstrap superuser is named POSTGRES according to this data and
  16. # according to BKI_DEFAULT entries in other catalogs. However, initdb
  17. # will replace that at database initialization time.
  18. { oid => '10', oid_symbol => 'BOOTSTRAP_SUPERUSERID',
  19. rolname => 'POSTGRES', rolsuper => 't', rolinherit => 't',
  20. rolcreaterole => 't', rolcreatedb => 't', rolcanlogin => 't',
  21. rolreplication => 't', rolbypassrls => 't', rolconnlimit => '-1',
  22. rolpassword => '_null_', rolvaliduntil => '_null_' },
  23. { oid => '6171', oid_symbol => 'ROLE_PG_DATABASE_OWNER',
  24. rolname => 'pg_database_owner', rolsuper => 'f', rolinherit => 't',
  25. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  26. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  27. rolpassword => '_null_', rolvaliduntil => '_null_' },
  28. { oid => '6181', oid_symbol => 'ROLE_PG_READ_ALL_DATA',
  29. rolname => 'pg_read_all_data', rolsuper => 'f', rolinherit => 't',
  30. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  31. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  32. rolpassword => '_null_', rolvaliduntil => '_null_' },
  33. { oid => '6182', oid_symbol => 'ROLE_PG_WRITE_ALL_DATA',
  34. rolname => 'pg_write_all_data', rolsuper => 'f', rolinherit => 't',
  35. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  36. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  37. rolpassword => '_null_', rolvaliduntil => '_null_' },
  38. { oid => '3373', oid_symbol => 'ROLE_PG_MONITOR',
  39. rolname => 'pg_monitor', rolsuper => 'f', rolinherit => 't',
  40. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  41. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  42. rolpassword => '_null_', rolvaliduntil => '_null_' },
  43. { oid => '3374', oid_symbol => 'ROLE_PG_READ_ALL_SETTINGS',
  44. rolname => 'pg_read_all_settings', rolsuper => 'f', rolinherit => 't',
  45. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  46. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  47. rolpassword => '_null_', rolvaliduntil => '_null_' },
  48. { oid => '3375', oid_symbol => 'ROLE_PG_READ_ALL_STATS',
  49. rolname => 'pg_read_all_stats', rolsuper => 'f', rolinherit => 't',
  50. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  51. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  52. rolpassword => '_null_', rolvaliduntil => '_null_' },
  53. { oid => '3377', oid_symbol => 'ROLE_PG_STAT_SCAN_TABLES',
  54. rolname => 'pg_stat_scan_tables', rolsuper => 'f', rolinherit => 't',
  55. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  56. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  57. rolpassword => '_null_', rolvaliduntil => '_null_' },
  58. { oid => '4569', oid_symbol => 'ROLE_PG_READ_SERVER_FILES',
  59. rolname => 'pg_read_server_files', rolsuper => 'f', rolinherit => 't',
  60. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  61. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  62. rolpassword => '_null_', rolvaliduntil => '_null_' },
  63. { oid => '4570', oid_symbol => 'ROLE_PG_WRITE_SERVER_FILES',
  64. rolname => 'pg_write_server_files', rolsuper => 'f', rolinherit => 't',
  65. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  66. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  67. rolpassword => '_null_', rolvaliduntil => '_null_' },
  68. { oid => '4571', oid_symbol => 'ROLE_PG_EXECUTE_SERVER_PROGRAM',
  69. rolname => 'pg_execute_server_program', rolsuper => 'f', rolinherit => 't',
  70. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  71. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  72. rolpassword => '_null_', rolvaliduntil => '_null_' },
  73. { oid => '4200', oid_symbol => 'ROLE_PG_SIGNAL_BACKEND',
  74. rolname => 'pg_signal_backend', rolsuper => 'f', rolinherit => 't',
  75. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  76. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  77. rolpassword => '_null_', rolvaliduntil => '_null_' },
  78. { oid => '4544', oid_symbol => 'ROLE_PG_CHECKPOINT',
  79. rolname => 'pg_checkpoint', rolsuper => 'f', rolinherit => 't',
  80. rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',
  81. rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',
  82. rolpassword => '_null_', rolvaliduntil => '_null_' },
  83. ]