Revoke grant with dblink in Postgres

89 Views Asked by At

I start to use dblink on my postgreSQL 11 db and I have a problem with grant. I can create server and user mapping as superuser , but also I can delete this user mapping and server as usual user. I try to revoke grant from usual user by

revoke grant option for all on foreign server my_server from not_my_role;

but it didn't help. How can I do it right?

1

There are 1 best solutions below

1
yuoggy On

As it turned out, my colleague created user mapping for usual role when he researched postgres_fdw. Probably dblink and postgres_fdw have bond.