I want to perform cross database queries using dblink, I loaded this module in the table. However when I use it I receive:
ERROR: permission denied for function dblink_connect_u
The solution would be:
GRANT EXECUTE ON FUNCTION dblink_connect_u(text,text) TO someuser
Now my questions.
1)Should this line be entered in the configuration file or executed with psql. If latter how does the syntax look?
2) Should this be done by superuser or someuser (no admin rights) can also do it?
3)How to grant rights for this function in all databases used?