Restore default privileges in PostgreSQL

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.

+4
source share
1 answer

.

, , , ( pg_class).

, -, DO plpgsql. , GRANT , , .

0

Source: https://habr.com/ru/post/1530622/


All Articles