Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. CREATE PUBLIC DATABASE LINK my_link CONNECT TO my_schema IDENTIFIED BY shema_password USING 'remote';
  2.  
  3. SELECT * FROM some_table@my_link;
  4.  
  5. SELECT *
  6. FROM dblink('host= port= dbname= user= password=',
  7. 'select table_schema, table_name from information_schema.tables where table_schema = ''data''') AS t1 (table_schema TEXT, table_name TEXT);
  8.  
  9. [2F003] ERROR: password is required
  10. Description: Non-superuser cannot connect if the server does not request a password.
  11. Help: Target server's authentication method must be changed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement