Re: BUG #7818: Foreign server not visible under normal users - Mailing list pgsql-bugs

abrosich@ogs.trieste.it writes:
> I installed oracle_fdw (version 0.9.8).
> Under "postgres" user works all fine and I can create tables and select from
> them.
> Despite the fact that I granted usage to a normal user (as specified in the
> documentation, with the command "GRANT USAGE ON FOREIGN SERVER server TO
> pguser;")
> , that user cannot see the server: \des gives an empty list and every
> command about foreign server gives an error (for example CREATE USER
> MAPPING...).

There is no permission-related filter in \des output.  What seems most
likely is that your "normal user" isn't connected to the same database
that you created the FDW and foreign server in.

            regards, tom lane