Skip site navigation (1) Skip section navigation (2)

Re: Regarding permissions

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Gaurav K Srivastav <gauravgkp(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Regarding permissions
Date: 2009-08-21 19:56:08
Message-ID: 603c8f070908211256q6ad1325dh7ce743c56f52e7c5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Aug 19, 2009 at 5:45 AM, Gaurav K Srivastav<gauravgkp(at)gmail(dot)com> wrote:
> HI,
>
> I have a normal user  'abcd' and grant all previliges to this user on the
> database 'pqr'.
> now i am unable to use dblink(text,text).
> while via super user 'postgre' which is the owner of database  'postgre'  I
> am able to use dblink(text,text).
> Can you please let me know how to get use of dblink(text,text) in normal
> user databse.
>
> while creating dblink(text,text) I got the error
> ERROR: permission denied for language c
> SQL state: 42501
>
> Please let me know that how to fix it.

This isn't a bug.  You might try -general or -novice.  I would also
suggest, as I did before, reading the docs for GRANT.

...Robert

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2009-08-21 19:58:37
Subject: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????
Previous:From: Tom LaneDate: 2009-08-21 18:35:18
Subject: Re: 8.4.0 data loss / HOT-related bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group