Re: Regarding permissions - Mailing list pgsql-bugs

From Robert Haas
Subject Re: Regarding permissions
Date
Msg-id 603c8f070908211256q6ad1325dh7ce743c56f52e7c5@mail.gmail.com
Whole thread Raw
In response to Regarding permissions  (Gaurav K Srivastav <gauravgkp@gmail.com>)
List pgsql-bugs
On Wed, Aug 19, 2009 at 5:45 AM, Gaurav K Srivastav<gauravgkp@gmail.com> wr=
ote:
> HI,
>
> I have a normal user=A0 'abcd' and grant all previliges to this user on t=
he
> database 'pqr'.
> now i am unable to use dblink(text,text).
> while via super user 'postgre' which is the owner of database=A0 'postgre=
'=A0 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.4.0 data loss / HOT-related bug
Next
From: Robert Haas
Date:
Subject: Re: When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????