Groups > comp.databases.postgresql > #653

User not allowed to create a server for foreign data wrapper

Newsgroups	comp.databases.postgresql
Date	2015-04-14 09:16 -0700
Message-ID	<73b17dd6-e4db-4ed8-8cd8-3a6c03e67f6e@googlegroups.com> (permalink)
Subject	User not allowed to create a server for foreign data wrapper
From	RKG <raphael.kong@gmail.com>

Show all headers | View raw

Hello guys,
I've been facing a credential issue on postgresql.
As postgres user, I create a template database ; I've added several extentions (mysql_fdw, compiled from https://github.com/EnterpriseDB/mysql_fdw) to this template, and create a database from this template.

A user own the this new database and have all privileges on it.

When I try to create a server for foreign data wrapper as this user, I have an error :

ERROR: right refused for Foreign Data Wrapper mysql_fdw
(ERREUR:  droit refusé pour le wrapper de données distantes mysql_fdw in french)

I guess there is something related to the extention creation but I can t figure out what.

Thx a lot !

Back to comp.databases.postgresql | Previous | Next | Find similar

Thread

User not allowed to create a server for foreign data wrapper RKG <raphael.kong@gmail.com> - 2015-04-14 09:16 -0700

csiph-web