Introduce a role_owner group into the PG permission system
authorKarl O. Pinc <kop@karlpinc.com>
Tue, 21 Jan 2025 20:31:31 +0000 (14:31 -0600)
committerKarl O. Pinc <kop@karlpinc.com>
Tue, 21 Jan 2025 20:31:31 +0000 (14:31 -0600)
commit5fdcc9dc1008fd86e48e5540b8278730d6963a9a
tree6a6220143da71e2d92a6b8cb3cf4ca30ac4ca8c1
parente2ac294482c127cf987740cc5a3b02cfbedd3473
Introduce a role_owner group into the PG permission system

This new role is used to assign permissions.  (The permissions granted
by membership in other roles.)  This prevents users from losing their
permissions when the creating role is dropped, as when an
administrator leaves.  It pushes the chicken-and-egg problem back to
the administrator level.  This is then handled by saying in the docs:
"Don't use a role that will go away when creating administrators."
bin/sokwedb-user-add.m4
bin/sokwedb-user-delete.m4
db/creategroups.m4
doc/src/architecture.m4
doc/src/architecture/permissions.m4 [new file with mode: 0644]
doc/src/architecture/users.m4
include/global_constants.m4