Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #653

User not allowed to create a server for foreign data wrapper

X-Received by 10.66.147.132 with SMTP id tk4mr27781188pab.23.1429028208341; Tue, 14 Apr 2015 09:16:48 -0700 (PDT)
X-Received by 10.140.30.118 with SMTP id c109mr266292qgc.15.1429028208292; Tue, 14 Apr 2015 09:16:48 -0700 (PDT)
Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!l13no5317466iga.0!news-out.google.com!k20ni166qgd.0!nntp.google.com!j5no1439300qga.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups comp.databases.postgresql
Date Tue, 14 Apr 2015 09:16:48 -0700 (PDT)
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=91.103.234.209; posting-account=jalVGwoAAADQ226ZovsV7olbdTawaR_B
NNTP-Posting-Host 91.103.234.209
User-Agent G2/1.0
MIME-Version 1.0
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>
Injection-Date Tue, 14 Apr 2015 16:16:48 +0000
Content-Type text/plain; charset=ISO-8859-1
Content-Transfer-Encoding quoted-printable
Xref csiph.com comp.databases.postgresql:653

Show key headers only | 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