Postgres permissions for nonexistent objects
0
votes
2
answers
41
views
Does dropping and recreating a postgres database (or schema or table) cause a loss of any granular permissions that were formerly associated with that resource?
For comparison, is it like a Posix filesystem (or Linux FACL) where the metadata is attached to the entries and so deleting and recreating a director tree will undo any granular permission changes, or is the metadata kept elsewhere (and with no foreign key constraint) so that the granular policies can be retained and still apply if any future database resources match those same names?
Asked by benjimin
(101 rep)
Feb 5, 2025, 08:06 AM
Last activity: Feb 8, 2025, 07:31 AM
Last activity: Feb 8, 2025, 07:31 AM