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