Thread: Regarding permissions

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.

Thnx & Rgds

Gaurav Kumar Srivastava

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