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> 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: 42501Please 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