Revoke grant with dblink in Postgres

Question

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?

dblink is not a fdw, it does not have user mappings. Please include enough details so we can understand what you are asking, and asking about--such as a minimal reproducible example. — jjanes
– jjanes, Commented Oct 24, 2022 at 11:50
If dblink does not have user mapping, why I can't open connection without it? And I can after create user mapping — yuoggy
– yuoggy, Commented Oct 25, 2022 at 5:29

yuoggy · Accepted Answer · 2022-10-25 05:35:40Z

0

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

answered Oct 25, 2022 at 5:35

yuoggy

1471 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Revoke grant with dblink in Postgres

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related