Is there a way to restore default privileges in a table in PostgreSQL?
After creating the table, if I run \zin psql, I see the following:
Schema | Name | Type | Access privileges | Column access privileges
--------+-------------+----------+---------------------------+-------------------------
public | example | table | |
phpPgAdmin also says that the privileges for the example table are the default values. If I edit these privileges, I would like to revert my changes. Is it possible? So far, I tried with REVOKE ALL, which actually displays an empty access privilege field at startup \z, but obviously does not work, since it removes all privileges even from the owner.
source
share