0

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?

yuoggy
  • 97
  • 1
  • 10
  • 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 Oct 24 '22 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 Oct 25 '22 at 05:29

1 Answers1

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.

yuoggy
  • 97
  • 1
  • 10
  • 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](/help/how-to-answer). – Community Oct 28 '22 at 09:20